ShiftCrew

Column Type
ShiftCrewID int identity
  • hdrResp/Personnel/NonRNLIQ/SISORU0035
ShiftID int
  • No mappings found.
CrewMemberID int
  • hdrResp/Personnel/CrewQ/SISORU0027
  • hdrResp/Personnel/OfficialsQ/SISORU0056
  • hdrResp/Personnel/PersonnelQ/SISORU0055
  • hdrResp/Personnel/ShoreCrewQ/SISORU0043
  • hdrOutcome/RehousingQ/SISORU0027
  • hdrTraining/Exercise/ExPersonnel/ExShoreCrew/SISORU0043
  • hdrTraining/Exercise/ExPersonnel/ExOfficials/SISORU0056
  • hdrTraining/Exercise/ExPersonnel/ExCrew/SISORU0027
FromTime datetime
  • hdrResp/Personnel/CrewQ/SISORU0039
  • hdrResp/Personnel/OfficialsQ/SISORU0039
  • hdrResp/Personnel/PersonnelQ/SISORU0636
  • hdrResp/Personnel/ShoreCrewQ/SISORU0625
  • hdrTraining/Exercise/ExPersonnel/ExShoreCrew/SISORU0039
  • hdrTraining/Exercise/ExPersonnel/ExOfficials/SISORU0039
  • hdrTraining/Exercise/ExPersonnel/ExCrew/SISORU0039
ToTime datetime
  • hdrResp/Personnel/CrewQ/SISORU0040
  • hdrResp/Personnel/OfficialsQ/SISORU0040
  • hdrResp/Personnel/PersonnelQ/SISORU0637
  • hdrResp/Personnel/ShoreCrewQ/SISORU0626
  • hdrTraining/Exercise/ExPersonnel/ExShoreCrew/SISORU0040
  • hdrTraining/Exercise/ExPersonnel/ExOfficials/SISORU0040
  • hdrTraining/Exercise/ExPersonnel/ExCrew/SISORU0040
IsOnboard bit
  • No mappings found.
AuthorisedLaunch bit
  • No mappings found.
ReHousedCraft bit
  • No mappings found.
ReasonPresent nvarchar
  • No mappings found.
PaymentStatus int
  • No mappings found.
PaymentHours decimal
  • No mappings found.
PaymentHoursAdjusted int
  • No mappings found.
ServicePay money
  • No mappings found.
AdditionalClaim bit
  • No mappings found.
RehousingClaim bit
  • No mappings found.
Claim bit
  • hdrResp/Personnel/CrewQ/SISORU0030
  • hdrResp/Personnel/ShoreCrewQ/SISORU0048
  • hdrOutcome/RehousingQ/SISORU0030
  • hdrTraining/Exercise/ExPersonnel/ExShoreCrew/SISORU0048
  • hdrTraining/Exercise/ExPersonnel/ExCrew/SISORU0030
PaymentMethodID int
  • No mappings found.
PayDate datetime
  • No mappings found.
PaymentAuthorisedBy nvarchar
  • No mappings found.
ReasonForAdjustment nvarchar
  • No mappings found.
AccDocNumber nvarchar
  • No mappings found.