| # |
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 |
SEQNO |
Number(5,0) |
INTEGER NOT NULL |
Sequence Number
Default Value: 0
|
| 5 |
EDUCATION_LVL_ARG |
Character(4) |
VARCHAR2(4) NOT NULL |
Education Level Argentina
EG=Elementary Eighth Year
FG=Elementary First Year
FIG=Elementary Fifth Year
FIY=High School Fifth Year
FK=Five Years Old Kindergarten
FOG=Elementary Fourth Year
FOK=Four Years Old Kindergarten
FOY=High School Fourth Year
FY=High School First Year
FYP=Polimodal First Year
NG=Elementary Ninth Year
SEG=Elementary Seventh Year
SG=Elementary Second Year
SIG=Elementary Sixth Year
SIY=High School Sixth Year
SPE=Special Education
SY=High School Second Year
SYP=Polimodal Second Year
TG=Elementary Third Year
THK=Three Years Old Kindergarten
TWK=Two Years Old Kindergarten
TY=High School Third Year
TYP=Polimodal Third Year
|
| 6 |
CERT_ST_ARG |
Character(1) |
VARCHAR2(1) NOT NULL |
School Certificate Start Year
Y/N Table Edit
Default Value: N
|
| 7 |
CERT_ST_YEAR_ARG |
Number(4,0) |
SMALLINT NOT NULL |
Certificate Starte Year
|
| 8 |
CERT_END_ARG |
Character(1) |
VARCHAR2(1) NOT NULL |
Certification End Year Flag
Y/N Table Edit
Default Value: N
|
| 9 |
CERT_END_YEAR_ARG |
Number(4,0) |
SMALLINT NOT NULL |
Certificate End Year
|
| 10 |
FAM_ALLW_ARG |
Character(1) |
VARCHAR2(1) NOT NULL |
Eligible for Family Allowance
Y/N Table Edit
Default Value: N
|
| 11 |
FAM_TERM_DT_ARG |
Date(10) |
DATE |
Family Allowance Termination Date
|
| 12 |
SIRADIG_ARG |
Character(1) |
VARCHAR2(1) NOT NULL |
Use to mark if record was uploaded by xml file for SIRADIG
N=No
Y=Yes
|
| 13 |
INC_TAX_DEPEN_ARG |
Character(1) |
VARCHAR2(1) NOT NULL |
Eligible for Income Tax
C=Child
O=Other Dependents
S=Spouse/Domestic Partner Adult
|
| 14 |
INC_TAX_BGNDT_ARG |
Date(10) |
DATE |
Income Tax Begin Date
|
| 15 |
INC_TAX_ENDDT_ARG |
Date(10) |
DATE |
Income Tax End Date
|
| 16 |
SOC_SEC_CON_ARG |
Character(1) |
VARCHAR2(1) NOT NULL |
Social Security Condition ARG
A=Adherent to Social Security
S=Eligible for Social Security
|
| 17 |
SOC_SEC_BGNDT_ARG |
Date(10) |
DATE |
Social Security Begin Date
|
| 18 |
SOC_SEC_ENDDT_ARG |
Date(10) |
DATE |
Social Security End Date
|
| 19 |
DOC_ISSUE_DT_ARG |
Date(10) |
DATE |
Document Issue Date
|
| 20 |
BOOK_ARG |
Character(6) |
VARCHAR2(6) NOT NULL |
Book
|
| 21 |
FOLIO_ARG |
Character(5) |
VARCHAR2(5) NOT NULL |
Folio
|
| 22 |
ACT_NUMBER_ARG |
Character(7) |
VARCHAR2(7) NOT NULL |
Act Number
|
| 23 |
BIRTH_MARRG_CD_ARG |
Character(4) |
VARCHAR2(4) NOT NULL |
Country Code for Birth Or Marriage
Prompt Table:
COUNTRY_TBL
|
| 24 |
BIRTH_MARRG_PL_ARG |
Character(30) |
VARCHAR2(30) NOT NULL |
Marriage Location
|
| 25 |
BIRTH_MARRG_ST_ARG |
Character(6) |
VARCHAR2(6) NOT NULL |
Marriage State
Prompt Table:
BIRMAR_ARG_VW
|
| 26 |
COMMUNE_ARG |
Character(30) |
VARCHAR2(30) NOT NULL |
Commune
|
| 27 |
TRIBUNAL_ARG |
Character(50) |
VARCHAR2(50) NOT NULL |
Tribunal
|
| 28 |
COURT_NBR_ARG |
Character(4) |
VARCHAR2(4) NOT NULL |
Court Number
Prompt Table:
COURT_TBL_ARG
|
| 29 |
SECRETARY_NBR_ARG |
Character(4) |
VARCHAR2(4) NOT NULL |
Secretary Number
Prompt Table:
SECRTRY_TBL_ARG
|
| 30 |
SCHOOL_YEAR_ARG |
Number(4,0) |
SMALLINT NOT NULL |
School Year
|
| 31 |
SCHOOL_TYPE_ARG |
Character(1) |
VARCHAR2(1) NOT NULL |
School Type
N=Normal
V=Summer
Default Value: N
|
| 32 |
SCHOOL_GRADE_ARG |
Character(2) |
VARCHAR2(2) NOT NULL |
School Grade
|
| 33 |
EVENT_CODE_ARG |
Character(2) |
VARCHAR2(2) NOT NULL |
Event Code
01=Total Adoption
03=Social Security Beneficiary
04=Coexistence
07=Divorce
09=Birth
12=Marriage
13=Safeguard
14=Custody
15=Wardship
19=Guardianship
23=Quit Custody
24=Stepchild
26=Social Security Benef End
30=Coexistence End
31=Stepchild End
32=Safeguard End
33=Custody End
34=Wardship End
35=Guardianship End
36=Quit Custody End
|
| 34 |
DJ_TEXT_ARG |
Character(70) |
VARCHAR2(70) NOT NULL |
DJ Text
|
| 35 |
DOC_CODE_ARG |
Character(2) |
VARCHAR2(2) NOT NULL |
Cocumentation Code
01=Birth
03=Marriage
11=Pa/Ce/Ac. ext. Birth
13=Pa/Ce/Ac. ext. Marriage
20=Adoption Judgment
21=Safeguard Judgment
22=Custody Judgment
23=Wardship Judgment
24=Divorce Judgment
28=Sworn Coexistence Stmt
36=Sworn Soc Sec Benef Stmt
39=Sworn Stepchild Stmt
58=Guardianship Judgment
62=Quit Custody Judgment
72=Sworn Soc Sec Benef End Stmt
73=Sworn Stepchild End Stmt
|
| 36 |
OVRSEAS_DOC_CD_ARG |
Character(2) |
VARCHAR2(2) NOT NULL |
Overseas Documentation Code
01=Overseas Entry
02=Overseas Certificate
03=Overseas Act
|
| 37 |
TAX_DEPEND_DED_ARG |
Character(3) |
VARCHAR2(3) NOT NULL |
Tax Dependent Deduction
050=50%
100=100%
Default Value: 100
|