INEMPLOYEE

REFERENCED BY
BN66.1 PR140 PR160 PR180 PR189 PR195
PR80.1 PR80.4 PR89.1 PRAT.1


UPDATED BY
BN305 HR11.1 HR11.2 HR11.4 HR13.1 HR28.1
HR511 HR513 LT101 LT111 ZH510 PA02.1
PA100 PA102 PA115 PA13.1 PA13.2 PA218
PA502 PA513 PA52.1 PA52.3 PA52.4 PA52.5
PR110 PR113 PR12.6 PR120 PR13.1 PR13.5
PR13.6 PR13.8 PR13.9 PR197 PR30.2 PR512

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CEM-COMPANY
Element: Company Hr
Numeric 4
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
CEM-EMPLOYEE
Element: Employee
Numeric 9
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
CEM-AADHAAR
Element: Aadhaar
Numeric 10
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
CEM-REASON-CDE
Element: Reason Cde
Alpha 2

2 = Left Service
3 = Retired
5 = Expired
8 = Suspension of work
10 = Retrenchment
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
CEM-PF-REG-NBR
Element: Pf Reg Nbr
Alpha 20
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
CEM-PF-ACCT-NBR
Element: Pf Acct Nbr
Numeric 7
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
CEM-ESIC-REGN-NBR
Element: Esic Regn Nbr
Alpha 20
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
CEM-ESIC-IP
Element: Esic Ip
Numeric 10
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
CEM-ESIC-REASON
Element: Esic Reason
Numeric 2

00 = Without Reason
01 = On Leave
04 = Out of Coverage
06 = Non Implemented Area
07 = Compliance by immediate compny
09 = Compliance by immediate compny
11 = No Work
12 = Doesn't belong to this employr
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR197
PR30.2 PR512
ZH510
CEM-LWF-REGN-NBR
Element: Lwf Regn Nbr
Alpha 18
CEM-NBR-STD-DEP
Element: Nbr Std Dep
Numeric 3
BN305 HR11.1
HR11.2 HR11.4
HR13.1 HR28.1
HR511 HR513
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA218 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
CEM-NBR-HOS-DEP
Element: Nbr Hos Dep
Numeric 3
BN305 HR11.1
HR11.2 HR11.4
HR13.1 HR28.1
HR511 HR513
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA218 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
CEM-FATHER-HUS-NME
Element: Father Hus Nme
Alpha 30
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
CEM-MEMBR-RELATION
Element: Membr Relation
Alpha 1

F = Father
H = Husband
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
CEM-HOLD-RESUME
Element: Hold Resume
Numeric 1

1 = Resume
2 = Process & Hold
3 = Do not process
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
CEM-GOVT-EMP
Element: Govt Emp
Alpha 1

Y = Yes
N = No
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
CEM-PF-CONTRIB
Element: Pf Contrib
Numeric 1

1 = Qualifying Amount
2 = Actual Earnings
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
CEM-DISABILITY-SEV
Element: Disability Sev
Alpha 1

0 = 0 to < 40%
1 = 40% to < 80%
2 = 80% + Above
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
CEM-DIRECTOR
Element: Director
Alpha 1

Y = Yes
N = No
CEM-CREATE-DATE
Element: Date Stamp
Numeric 8 (yyyymmdd)
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
CEM-CREATE-TIME
Element: Time Stamp
Numeric 6 (hhmmss)
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
CEM-CREATE-USER-ID
Element: User Id
Alpha 10 (Lower Case)
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
CEM-DATE-STAMP
Element: Date Stamp
Numeric 8 (yyyymmdd)
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
CEM-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
CEM-USER-ID
Element: User Id
Alpha 10 (Lower Case)
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510


INEMPLOYEE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CEMSET1 COMPANY
EMPLOYEE
...
BN305 BN66.1
HR11.1 HR11.2
HR11.4 HR13.1
HR28.1 HR511
HR513 LT101
LT111 ZH510
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA218 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1


INEMPLOYEE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Employee EMPLOYEE Required
CEM-COMPANY->EMP-COMPANY
CEM-EMPLOYEE->EMP-EMPLOYEE


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

Home
Contact Us



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