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.