DEP_BENEF_CHN(SQL Table) |
Index Back |
|---|---|
Dependent/Benef - ChinaDependent Beneficiaries effective dated fiscal data for China |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | DEPENDENT_BENEF |
Character(2) | VARCHAR2(2) NOT NULL |
Dependent Benefit
01=default |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | POLITICAL_STA_CHN | Character(4) | VARCHAR2(4) NOT NULL |
Political status of employees in China
1=CPC Member 10=JIU SAN Society Member 11=TW Democratic Self-Federate 12=DPWPA 13=Masses 2=CPC Member Prepared 3=League Member 4=KRC Member 5=NLD Federate 6=DNCA Member 7=Dan Member 8=AAIP Member 9=China ZHI GONG Dang Party 99=Other |
| 5 | NATIVE_PLACE_CHN | Character(30) | VARCHAR2(30) NOT NULL | Native place for employees in China |