GPAR_BENEF_VW

#	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
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
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
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
11	FAM_TERM_DT_ARG	Date(10)	DATE	Family Allowance Termination Date
12	INC_TAX_DEPEN_ARG	Character(1)	VARCHAR2(1) NOT NULL	Eligible for Income Tax C=Child O=Other Dependents S=Spouse
13	INC_TAX_BGNDT_ARG	Date(10)	DATE	Income Tax Begin Date
14	INC_TAX_ENDDT_ARG	Date(10)	DATE	Income Tax End Date
15	SOC_SEC_CON_ARG	Character(1)	VARCHAR2(1) NOT NULL	Social Security Condition ARG A=Adherent to Social Security S=Eligible for Social Security
16	SOC_SEC_BGNDT_ARG	Date(10)	DATE	Social Security Begin Date
17	SOC_SEC_ENDDT_ARG	Date(10)	DATE	Social Security End Date
18	DOC_ISSUE_DT_ARG	Date(10)	DATE	Document Issue Date
19	BOOK_ARG	Character(6)	VARCHAR2(6) NOT NULL	Book
20	FOLIO_ARG	Character(5)	VARCHAR2(5) NOT NULL	Folio
21	ACT_NUMBER_ARG	Number(7,0)	INTEGER NOT NULL	Act Number
22	BIRTH_MARRG_CD_ARG	Character(4)	VARCHAR2(4) NOT NULL	Country Code for Birth Or Marriage
23	BIRTH_MARRG_PL_ARG	Character(30)	VARCHAR2(30) NOT NULL	Marriage Location
24	BIRTH_MARRG_ST_ARG	Character(6)	VARCHAR2(6) NOT NULL	Marriage State
25	COMMUNE_ARG	Character(30)	VARCHAR2(30) NOT NULL	Commune Arg
26	TRIBUNAL_ARG	Character(50)	VARCHAR2(50) NOT NULL	Tribunal
27	COURT_NBR_ARG	Character(4)	VARCHAR2(4) NOT NULL	Court number
28	SECRETARY_NBR_ARG	Character(4)	VARCHAR2(4) NOT NULL	Secretary Number
29	SCHOOL_YEAR_ARG	Number(4,0)	SMALLINT NOT NULL	School Year
30	SCHOOL_TYPE_ARG	Character(1)	VARCHAR2(1) NOT NULL	School Type N=Normal V=Summer
31	SCHOOL_GRADE_ARG	Character(2)	VARCHAR2(2) NOT NULL	School Grade
32	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
33	DJ_TEXT_ARG	Character(70)	VARCHAR2(70) NOT NULL	DJ Text
34	DOC_CODE_ARG	Character(2)	VARCHAR2(2) NOT NULL	Documentation 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
35	OVRSEAS_DOC_CD_ARG	Character(2)	VARCHAR2(2) NOT NULL	Overseas Documentation Code 01=Overseas Entry 02=Overseas Certificate 03=Overseas Act
36	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company