C6PREVEMP

REFERENCED BY
PR139 PR141


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

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
C6E-COMPANY
Element: Hr Company
Numeric 4
C6E-EMPLOYEE
Element: Employee
Numeric 9
C6E-PAYROLL-YEAR
Element: Payroll Year
Numeric 4
C6E-EFFECT-DATE
Element: Effect Date
Numeric 8 (yyyymmdd)
C6E-END-DATE
Element: Effect Date
Numeric 8 (yyyymmdd)
C6E-PREV-EMPLOYER
Element: Name
Alpha 30 (Lower Case)
C6E-PREV-TYPE
Element: Prev Type
Alpha 1

G = Gross Perquisites
T = Tax Deducted at Source
1 = Section 10
2 = Section 24
3 = Section 16
4 = Section 80C
5 = Section VI-A
C6E-PREV-CODE
Element: Sec Code
Alpha 10
C6E-ACTUAL-AMOUNT
Element: Act Amount
Signed 13.2
C6E-AMOUNT-OLD
Element: Act Amount
Signed 13.2
C6E-APPROVE-FLG
Element: Approve Flg
Alpha 1

Y = Yes
N = No
R = Rejected
C6E-APPROVED-AMT
Element: Approved Amt
Signed 13.2
C6E-REQUEST-AMT
Element: Request Amt
Signed 13.2
C6E-PROC-STATUS
Element: Proc Status
Alpha 1

0 = Unprocessed
P = Pending
C = Closed
BN66.1 PR140
PR189 PR195
PR197 PR80.1
PR80.4 PR89.1
PRAT.1
C6E-USER-FLAG
Element: Flag Num
Numeric 1

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


C6PREVEMP FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
C6ESET1 COMPANY
EMPLOYEE
PAYROLL-YEAR
PREV-TYPE
PREV-CODE
BN66.1 PR139
PR140 PR141
PR189 PR195
PR197 PR80.1
PR80.4 PR89.1
PRAT.1


C6PREVEMP FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Not Required
C6E-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Employee INEMPLOYEE Required
C6E-COMPANY->CEM-COMPANY
C6E-EMPLOYEE->CEM-EMPLOYEE
Investment C6INVEST Not Required
C6E-COMPANY->C6I-COMPANY
C6E-PAYROLL-YEAR->C6I-PAYROLL-YEAR
C6E-PREV-TYPE->C6I-INV-GROUP
C6E-PREV-CODE->C6I-INV-CODE


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

Home
Contact Us



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