<CIFADDRESSBOOKEMPLOYMENTDETAILS> - Sub element of <CIFADDRESSBOOK>
NLS 5.7
| Attribute | Type | Size | REQ | Default | Comments |
|---|---|---|---|---|---|
HireDate
|
Date | No | MM/dd/yyyy or as configured by the DATEFMT user defined parameter. | ||
EndDate
|
Date | No | MM/dd/yyyy or as configured by the DATEFMT user defined parameter. | ||
NumOfYearsOnJob
|
Numeric | 10 | No | Used to calculate hire_date if HireDate is not specified. This value is not stored in the database. |
|
NumOfMonthsOnJob5.21+
|
Numeric | 10 | No | Used to calculate hire_date if HireDate is not specified. This value is not stored in the database. |
|
Occupation5.20-
|
String | ≤25 | No | ||
Occupation5.21+
|
String | ≤35 | No | ||
Position
|
String | ≤25 | No | ||
NumOfYearsInLineOfWork
|
Numeric | 10 | No | Used to calculate career_date. This value is not stored in the database. | |
NumOfMonthsInLineOfWork5.21+
|
Numeric | 10 | No | Used to calculate career_date. This value is not stored in the database. | |
SelfEmployed
|
String | Yes | TRUE or FALSESelfEmployed and Military are mutually exclusive. |
||
MonthlyGrossIncome
|
Numeric | 16,2 | No | ||
MonthlyNetIncome
|
Numeric | 16,2 | No | ||
YearlyGrossIncome
|
Numeric | 16,2 | No | ||
YearlyNetIncome
|
Numeric | 16,2 | No | ||
DirectDeposit
|
String | Yes | TRUE or FALSE |
||
PayFrequencyType
|
String | ≤25 | No |
Valid values:DailyWeeklyBi-WeeklySemi-Monthly (1 and 15)Semi-Monthly (1 and 16)Semi-Monthly (15 and EOM)MonthlyMonthly (Last Day of Month)5.19-Monthly - Pinned5.20+ |
|
DayOfWeek
|
Numeric | 10 | No |
Valid values:1 = Sunday2 = Monday3 = Tuesday4 = Wednesday5 = Thursday6 = Friday7 = Saturday
|
|
DayOfMonth
|
Numeric | 10 | No |
Valid values:1 – 3132 = last day of the month
|
|
WeekNumber
|
Numeric | 10 | No | Valid values:1 = First2 = Second3 = Third4 = Fourth5 = Last |
|
LastPayDate
|
Date | No | MM/dd/yyyy or as configured by the DATEFMT user defined parameter. | ||
NextPayDate
|
Date | No | MM/dd/yyyy or as configured by the DATEFMT user defined parameter. | ||
SubsequentPayDate5.35.4+
|
Date | No | MM/dd/yyyy or as configured by the DATEFMT user defined parameter. | ||
PrimaryEmployer
|
String | Yes | TRUE or FALSE |
||
ProofOfIncome
|
Date | No | MM/dd/yyyy or as configured by the DATEFMT user defined parameter. | ||
Military5.21+
|
String | No | TRUE or FALSEMilitary and SelfEmployed are mutually exclusive. |
||
MilitaryRank5.21+
|
String | 3 | No* | Valid values:E1 – E9W1 – W5O1 – O10*Required if Military = TRUE. |
|
TypeOfDuty5.21+
|
String | 15 | No* | Valid values:"" = NULLActive DutyReserve*Required if Military = TRUE. |
|
BranchOfService5.21+
|
String | 20 | No* | Valid values:Air ForceArmyCoast GuardMarine CorpsNavyNational GuardReserves*Required if Military = TRUE. |
|
EnlistmentDate5.21+
|
Date | No | MM/dd/yyyy or as configured by the DATEFMT user defined parameter. | ||
ReEnlistmentDate5.21+
|
Date | No | MM/dd/yyyy or as configured by the DATEFMT user defined parameter. | ||
SeparationDate5.21+
|
Date | No | MM/dd/yyyy or as configured by the DATEFMT user defined parameter. | ||
UnitNumber5.21+
|
Numeric | 5 | No | ||
MoveInDate5.23+
|
Date | No | MM/dd/yyyy or as configured by the DATEFMT user defined parameter. | ||
MoveOutDate5.23+
|
Date | No | MM/dd/yyyy or as configured by the DATEFMT user defined parameter. | ||
OwnRentFlag5.23+
|
Numeric | 1 | No | 0 | 0 = Own1 = Rent |
CurrentStatus5.26+
|
String | 20 | No | ||
HoursPerWeek5.26+
|
Numeric | 6 | No | ||
HourlyPay5.26+
|
Numeric | 6 | No | ||
FirstDayOfMonth5.26+
|
Numeric | 10 | No | Required only when PayFrequencyType is Semi-Monthly. |
|
SecondDayOfMonth5.26+
|
Numeric | 10 | No | Required only when PayFrequencyType is Semi-Monhtly. |
