|
CrewPositionOffers |
  
|
|
CrewPositionOffers |
|
IDX AutoInc NOT NULL,
xPosition Integer DESCRIPTION 'link to CrewPosition.idx',
xPerson Integer DESCRIPTION 'link to Name2.NameCounter',
LastModifiedBy Integer DESCRIPTION 'link to Users.UID',
CorrespondenceType Integer DESCRIPTION 'link to CorrespondenceTypes.idx',
OfferStatusDate Timestamp,
OfferStatus Byte DEFAULT 0 DESCRIPTION 'TCrewOfferStatus = (cosShortlisted, cosContacted, cosUnavailable, cosPossiblyAvailablity, cosAvailable, cosRejected, cosPencille',
CorrespondenceDate Timestamp DESCRIPTION 'Logs the date any correspondence with a crew person happens',
CrewPositions
IDX AutoInc NOT NULL,
xCrewRequest Integer DESCRIPTION 'link to Crew.idx',
xPerson Integer DESCRIPTION 'link to Name2.NameCounter',
Status Byte DEFAULT 0 DESCRIPTION 'TShiftStatus = (ssUnprocessed, ssInProgress, ssPencilled, ssBooked, ssOrdered)',
OrderStatus Byte DEFAULT 0 DESCRIPTION 'TPositionOrderStatus = (posNone, osOutstanding, posFullfilled)',
Description VarChar(50),