C6EMPINV

UPDATED BY
BN66.1 PR140 PR189 PR195 PR197 PR80.1
PR80.4 PR89.1 PRAT.1 PR141 PR139

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CEI-COMPANY
Element: Company Hr
Numeric 4
CEI-PAYROLL-YEAR
Element: Payroll Year
Numeric 4
CEI-EMPLOYEE
Element: Employee
Numeric 9
CEI-PRD-START-DATE
Element: Start Date
Numeric 8 (yyyymmdd)
CEI-INV-GROUP
Element: Inv Group
Alpha 1

1 = Section 10
2 = Section 24
3 = Section 16
4 = Section 80C
5 = Section VI-A
CEI-INV-CODE
Element: Sec Code
Alpha 10
CEI-PRD-END-DATE
Element: End Date
Numeric 8 (yyyymmdd)
CEI-INV-PROP-AMT
Element: Amount Ytd
Signed 13.2
CEI-INV-ACT-AMT
Element: Amount Ytd
Signed 13.2
CEI-PROC-STATUS
Element: Flag
Alpha 1

P = Pending
C = Closed
BN66.1 PR140
PR189 PR195
PR197 PR80.1
PR80.4 PR89.1
PRAT.1
CEI-SEQ-NBR
Element: Seq Nbr
Numeric 4
CEI-APPROVE-FLG
Element: Approve Flg
Alpha 1

Y = Yes
N = No
CEI-REQUEST-AMT
Element: Request Amt
Signed 13.2
CEI-APPROVED-AMT
Element: Approved Amt
Signed 13.2
CEI-USER-FLAG
Element: Flag Num
Numeric 1

0 = No
1 = Yes
CEI-CREATE-USER-ID
Element: User
Alpha 10 (Lower Case)
CEI-CREATE-DATE
Element: Date Stamp
Numeric 8 (yyyymmdd)
CEI-CREATE-TIME
Element: Time Stamp
Numeric 6 (hhmmss)
CEI-USER-ID
Element: User
Alpha 10 (Lower Case)
CEI-DATE-STAMP
Element: Date Stamp
Numeric 8 (yyyymmdd)
CEI-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)


C6EMPINV FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CEISET1 COMPANY
PAYROLL-YEAR
EMPLOYEE
PRD-START-DATE*
INV-GROUP
INV-CODE
SEQ-NBR
BN66.1 PR140
PR141 PR189
PR195 PR197
PR80.1 PR80.4
PR89.1 PRAT.1
CEISET2 COMPANY
PAYROLL-YEAR
EMPLOYEE
PRD-START-DATE*
INV-GROUP
INV-CODE
SEQ-NBR*
BN66.1 PR139
PR140 PR189
PR195 PR80.1
PR80.4 PR89.1
PRAT.1


C6EMPINV FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
CEI-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Employee EMPLOYEE Required
CEI-COMPANY->EMP-COMPANY
CEI-EMPLOYEE->EMP-EMPLOYEE
Investment C6INVEST Required
CEI-COMPANY->C6I-COMPANY
CEI-PAYROLL-YEAR->C6I-PAYROLL-YEAR
CEI-INV-GROUP->C6I-INV-GROUP
CEI-INV-CODE->C6I-INV-CODE


C6EMPINV FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Pay Period C6PRDDTL
CEI-COMPANY->C6D-COMPANY
CEI-PAYROLL-YEAR->C6D-PAYROLL-YEAR
  C6D-PAY-PRD-DEF
  C6D-START-DATE


File created: Thu Jun 09 02:11:52 2016

Home
Contact Us



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