CMUSERFLD

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CMU-COMPANY
Element: Company Hr
Numeric 4
CMU-EMPLOYEE
Element: Employee
Numeric 9
CMU-CONTRACT-NBR
Element: Seq Number
Numeric 6
CMU-USR-FLD-SEQ
Element: Seq Number
Numeric 6
CMU-SEGMENT-TYPE
Element: Segment Type
Alpha 1

1 = Contract Record
2 = Base Assignment Record
3 = Supplemental Assignment Record
CMU-SEGMENT-NBR
Element: Seq Number
Numeric 6
CMU-CONTRACT-YEAR
Element: Cw Contract Yr
Numeric 4
CMU-USR-FLD-TYPE
Element: Field Type
Alpha 1
CMU-USR-FIELD-NAME
Element: Field Name
Alpha 20 (Lower Case)
CMU-A-VALUE
Element: Cw User Alpha
Alpha 20 (Lower Case)
CMU-S-VALUE
Element: Cw Amount
Signed 18.6
CMU-D-VALUE
Element: Cw Date
Numeric 8 (yyyymmdd)
CMU-CREATE-DATE
Element: Date Stamp
Numeric 8 (yyyymmdd)
CMU-CREATE-TIME
Element: Time Stamp
Numeric 6 (hhmmss)
CMU-CREATE-USER-ID
Element: User
Alpha 10 (Lower Case)
CMU-DATE-STAMP
Element: Date Stamp
Numeric 8 (yyyymmdd)
CMU-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
CMU-USER-ID
Element: User
Alpha 10 (Lower Case)


CMUSERFLD FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CMUSET1 COMPANY
EMPLOYEE
CONTRACT-NBR*
SEGMENT-NBR*
USR-FLD-SEQ*
CMUSET2 COMPANY
EMPLOYEE
CONTRACT-NBR*
SEGMENT-TYPE
SEGMENT-NBR*
USR-FLD-TYPE
USR-FLD-SEQ
CMUSET3 COMPANY
CONTRACT-YEAR*
USR-FLD-TYPE
EMPLOYEE
CONTRACT-NBR*
USR-FLD-SEQ


CMUSERFLD FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Assignment CMASSIGN Required
CMU-COMPANY->CAS-COMPANY (CASSET1)
CMU-EMPLOYEE->CAS-EMPLOYEE
CMU-CONTRACT-NBR->CAS-CONTRACT-NBR
CMU-SEGMENT-NBR->CAS-SEGMENT-NBR
Company PRSYSTEM Required
CMU-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Contract CMCONTRACT Required
CMU-COMPANY->CNR-COMPANY
CMU-EMPLOYEE->CNR-EMPLOYEE
CMU-CONTRACT-NBR->CNR-CONTRACT-NBR
Employee EMPLOYEE Required
CMU-COMPANY->EMP-COMPANY
CMU-EMPLOYEE->EMP-EMPLOYEE
Paemployee PAEMPLOYEE Required
CMU-COMPANY->PEM-COMPANY
CMU-EMPLOYEE->PEM-EMPLOYEE


File created: Thu Jun 09 11:12:09 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.