<CIFTOCIFRELATIONSHIPEMPLOYMENTDETAILS> - Sub element of <CIFTOCIFRELATIONSHIP>

NLS 5.28
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.
NumOfMonthsOnJob Numeric 10 No   Used to calculate hire_date if HireDate is not specified. This value is not stored in the database.
Occupation String ≤35 No    
Position String ≤25 No    
NumOfYearsInLineOfWork Numeric 10 No   Used to calculate career_date. This value is not stored in the database.
NumOfMonthsInLineOfWork Numeric 10 No   Used to calculate career_date. This value is not stored in the database.
SelfEmployed String   Yes   TRUE or FALSE
SelfEmployed 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:
Daily
Weekly
Bi-Weekly
Semi-Monthly (1 and 15)
Semi-Monthly (1 and 16)
Semi-Monthly (15 and EOM)
Monthly
Monthly - Pinned
DayOfWeek Numeric 10 No   Valid values:
1 = Sunday
2 = Monday
3 = Tuesday
4 = Wednesday
5 = Thursday
6 = Friday
7 = Saturday
DayOfMonth Numeric 10 No   Valid values:
1 – 31
32 = last day of the month
WeekNumber Numeric 10 No   Valid values:
1 = First
2 = Second
3 = Third
4 = Fourth
5 = 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.
PrimaryEmployer String   Yes   TRUE or FALSE
ProofOfIncome Date   No   MM/dd/yyyy or as configured by the DATEFMT user defined parameter.
Military String   No   TRUE or FALSE
Military and SelfEmployed are mutually exclusive.
MilitaryRank String 3 No*   Valid values:
E1 – E9
W1 – W5
O1 – O10
*Required if Military = TRUE.
TypeOfDuty String 15 No*   Valid values:
"" = NULL
Active Duty
Reserve
*Required if Military = TRUE.
BranchOfService String 20 No*   Valid values:
Air Force
Army
Coast Guard
Marine Corps
Navy
National Guard
Reserves
*Required if Military = TRUE.
EnlistmentDate Date   No   MM/dd/yyyy or as configured by the DATEFMT user defined parameter.
ReEnlistmentDate Date   No   MM/dd/yyyy or as configured by the DATEFMT user defined parameter.
SeparationDate Date   No   MM/dd/yyyy or as configured by the DATEFMT user defined parameter.
UnitNumber Numeric 5 No    
MoveInDate Date   No   MM/dd/yyyy or as configured by the DATEFMT user defined parameter.
MoveOutDate Date   No   MM/dd/yyyy or as configured by the DATEFMT user defined parameter.
OwnRentFlag Numeric 1 No 0 0 = Own
1 = Rent
CurrentStatus String 20 No    
HoursPerWeek Numeric 6 No    
HourlyPay Numeric 6 No    
FirstDayOfMonth Numeric 10 No   Required only when PayFrequencyType is Semi-Monthly.
SecondDayOfMonth Numeric 10 No   Required only when PayFrequencyType is Semi-Monhtly.