REFERENCED BY
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | |
---|---|---|---|
CNR-COMPANY Element: Company Hr | Numeric 4 |
|
|
CNR-EMPLOYEE Element: Employee | Numeric 9 |
|
|
CNR-CONTRACT-NBR Element: Seq Number | Numeric 6 |
|
|
CNR-WORK-SCHED Element: Code | Alpha 10 |
|
|
CNR-CONTRACT-YEAR Element: Cw Contract Yr | Numeric 4 |
|
|
CNR-CONTRACT-GROUP Element: Group | Alpha 15 |
|
|
CNR-START-DATE Element: Start Date | Numeric 8 (yyyymmdd) |
|
|
CNR-END-DATE Element: End Date | Numeric 8 (yyyymmdd) |
|
|
CNR-START-DT-OVR Element: Cw Dte Ovr Flg | Numeric 1 0 = No 1 = Yes |
|
|
CNR-END-DT-OVR Element: Cw Dte Ovr Flg | Numeric 1 0 = No 1 = Yes |
|
|
CNR-STATUS Element: Cw Cont Status | Numeric 1 0 = Open 3 = Void 9 = Closed |
|
|
CNR-CLOSE-DATE Element: Close Date | Numeric 8 (yyyymmdd) |
|
|
CNR-PAYOUT Element: Cont Payout | Numeric 1 0 = No 1 = Payout in Full 2 = Payout Reserve only 3 = Payout Summer Deferral |
|
|
CNR-NBR-PAY-CYCLES Element: Cw Pay Cycles | Numeric 3 |
|
|
CNR-PAY-CYC-OVR Element: Override Flg | Numeric 1 |
|
|
CNR-FULL-AMT Element: Cw Full Amt | Signed 18.6 |
|
|
CNR-FULL-UNITS Element: Cw Full Units | Signed 18.6 |
|
|
CNR-EST-CNR-AMT Element: Cw Full Amt | Signed 18.6 |
|
|
CNR-BENEFIT-SAL Element: Flag | Alpha 1 Occurs 5 Times |
|
|
CNR-RIGHT Element: Right | Alpha 10 |
|
|
CNR-CHECK-GRP Element: Check Grp | Alpha 1 |
|
|
CNR-PROCESS-GRP Element: Process Grp | Alpha 1 |
|
|
CNR-TAX-FREQ-OVER Element: Tax Freq Over | Numeric 3 001 = Weekly 002 = Biweekly 003 = Semi-Monthly 004 = Monthly 005 = Daily 006 = Quarterly 007 = Semi-Annual 008 = Annual 009 = 9 Month Academic Monthly 010 = 10 Month Academic Monthly |
|
|
CNR-PAY-CYCLE Element: Pay Cycle | Alpha 1 Occurs 9 Times |
|
|
CNR-YTD-PAID-WAGES Element: Cw Ytd Paid Wg | Signed 18.6 |
|
|
CNR-YTD-PAID-UNITS Element: Cw Ytd Paid Ut | Signed 18.6 |
|
|
CNR-YTD-DOCKED-WGS Element: Cw Ytd Dock Wg | Signed 18.6 |
|
|
CNR-YTD-DOCKED-UTS Element: Cw Ytd Dock Ut | Signed 18.6 |
|
|
CNR-WAGE-BALANCE Element: Cw Wage Balanc | Signed 18.6 |
|
|
CNR-UNITS-BALANCE Element: Cw Unit Balan | Signed 18.6 |
|
|
CNR-RESERVE-BAL Element: Cw Res Bal | Signed 18.6 |
|
|
CNR-RESERVE-UNITS Element: Cw Res Units | Signed 18.6 |
|
|
CNR-UNITS-WORKED Element: Cw Units Wrkd | Signed 18.6 |
|
|
CNR-UNITS-REMAIN Element: Units Remain | Signed 18.6 |
|
|
CNR-EP-RESV-PAYOUT Element: Cont Payout | Numeric 1 0 = No 1 = Lump Sum 2 = By Pay Cycle |
|
|
CNR-EP-CHECK-GRP Element: Check Grp | Alpha 1 |
|
|
CNR-EP-PROCESS-GRP Element: Process Grp | Alpha 1 |
|
|
CNR-UNIT-TYPE Element: Cw Unit Type | Numeric 1 1 = Hours 2 = Days 3 = Zero Annual Units |
|
|
CNR-BEN-ELIG-FLAG Element: Ben Elig Flag | Numeric 1 |
|
|
CNR-CES-STATUS Element: Cw Status | Numeric 1 0 = Open 9 = Closed |
|
|
CNR-CREATE-DATE Element: Date Stamp | Numeric 8 (yyyymmdd) |
|
|
CNR-CREATE-TIME Element: Time Stamp | Numeric 6 (hhmmss) |
|
|
CNR-CREATE-USER-ID Element: User | Alpha 10 (Lower Case) |
|
|
CNR-DATE-STAMP Element: Date Stamp | Numeric 8 (yyyymmdd) |
|
|
CNR-TIME-STAMP Element: Time Stamp | Numeric 6 (hhmmss) |
|
|
CNR-USER-ID Element: User | Alpha 10 (Lower Case) |
|
|
CNR-LATE-STEP-DOWN Element: Flag Num | Numeric 1 0 = No 1 = Yes |
|
|
CNR-EQUALIZE-WAGE Element: Flag Num | Numeric 1 0 = No 1 = Yes; No Adjustment 2 = Yes; With Adjustment |
|
|
CNR-TRUNCATE-AMT Element: Flag Num | Numeric 1 0 = No 1 = Yes |
|
|
CNR-TOLERANCE-AMT Element: Cw Round To | Signed 18.6 |
|
|
CNR-WITHHOLD-RES Element: Flag Num | Numeric 1 0 = No 1 = Yes |
|
|
CNR-YTD-SUMR-DEFRL Element: Cw Ytd Paid Wg | Signed 18.6 |
|
|
CNR-HRH-OBJ-ID Element: Obj Id | Numeric 12 |
|
|
CNR-YTD-UNTS-DEFRL Element: Cw Ytd Paid Ut | Signed 18.6 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | |||||||
---|---|---|---|---|---|---|---|---|---|---|
CNRSET1 |
COMPANY EMPLOYEE CONTRACT-NBR* |
|
||||||||
CNRSET2 |
COMPANY CONTRACT-YEAR* EMPLOYEE CONTRACT-NBR* |
|
||||||||
CNRSET3 |
COMPANY CONTRACT-YEAR WORK-SCHED EMPLOYEE CONTRACT-NBR |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Company | PRSYSTEM |
Required
| ||||||||||||
Contract Group | PCODES |
Required
| ||||||||||||
Contract Right | PCODES |
Required
| ||||||||||||
Employee | EMPLOYEE |
Required
| ||||||||||||
Paemployee | PAEMPLOYEE |
Required
| ||||||||||||
Work Schedule | HRWRKSCHD |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Assignments | CMASSIGN |
Delete Cascades
| ||||||||||||
Contract Rule | CMCONTRULE |
|
All trademarks and registered trademarks are the property of their
respective owners.