MATR_BOOK_ITA

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
2	REG_REGION	Character(5)	VARCHAR2(5) NOT NULL	Regulatory Region Prompt Table: REG_STANDARD_VW
3	EMPL_CLASS	Character(3)	VARCHAR2(3) NOT NULL	Employee Classification Prompt Table: EMPL_CLASS_TBL
4	MATRICULA_NBR_ITA	Number(6,0)	INTEGER NOT NULL	Matricula Number ITA
5	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
6	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
7	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
8	NID_SPECIAL_CHAR	Character(20)	VARCHAR2(20) NOT NULL	NID as stored
9	BIRTHCOUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Birth Country Prompt Table: COUNTRY_TBL
10	BIRTHDATE	Date(10)	DATE	Date of Birth
11	BIRTHPLACE	Character(30)	VARCHAR2(30) NOT NULL	Birth Location
12	BIRTHSTATE	Character(6)	VARCHAR2(6) NOT NULL	Birth State Prompt Table: STATE_NAMES_TBL
13	MAR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Marital Status C=Common-Law D=Divorced E=Separated H=Head of Household L=DissDeclLost Civil Partner M=Married P=Civil Partnership S=Single T=Surviving Civil Partner U=Unknown V=Dissolved Civil Partnership W=Widowed
14	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: SCC_CNT_ADFMTVW
15	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
16	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
17	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
18	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
19	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
20	NUM1	Character(6)	VARCHAR2(6) NOT NULL	Number 1
21	NUM2	Character(6)	VARCHAR2(6) NOT NULL	Number 2
22	HOUSE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	House Type AB=House Boat Reference WW=House Trailer Reference
23	ADDR_FIELD1	Character(2)	VARCHAR2(2) NOT NULL	Address Field 1
24	ADDR_FIELD2	Character(4)	VARCHAR2(4) NOT NULL	Address Field 2
25	ADDR_FIELD3	Character(4)	VARCHAR2(4) NOT NULL	Address Field 3
26	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
27	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TBL
28	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
29	GEO_CODE	Character(11)	VARCHAR2(11) NOT NULL	Geo Code
30	IN_CITY_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	In City Limit Y/N Table Edit
31	TERMINATION_DT	Date(10)	DATE	Termination Date
32	WB_CODE_ITA	Character(20)	VARCHAR2(20) NOT NULL	Workbook Code ITA
33	WB_REL_CITY_ITA	Character(30)	VARCHAR2(30) NOT NULL	Workbook Release City
34	WB_REL_DATE_ITA	Date(10)	DATE	Workbook Release Date ITA
35	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
36	LABOR_AGREEMENT	Character(6)	VARCHAR2(6) NOT NULL	Labor Agreement Prompt Table: EMPL_CTG
37	SETID_LBR_AGRMNT	Character(5)	VARCHAR2(5) NOT NULL	Labor Agreement SetID
38	EMPL_CTG	Character(6)	VARCHAR2(6) NOT NULL	Employee Category Prompt Table: EMPL_CTG_L1
39	EMPL_CTG_L1	Character(6)	VARCHAR2(6) NOT NULL	Employee Subcategory Prompt Table: EMPL_CTG_L2
40	EMPL_CTG_L2	Character(6)	VARCHAR2(6) NOT NULL	Employee Subcategory 2 Prompt Table: EMPL_CTG_L3
41	SPECIAL_HIRCTG_ITA	Character(1)	VARCHAR2(1) NOT NULL	Special Hiring Category 1=Mobility List 2=CIG List 3=Unemployed List 4=Unemployed - Weak Wrap 5=Protected
42	INPS_CODE_ITA	Character(12)	VARCHAR2(12) NOT NULL	INPS Code ITA Prompt Table: E_INPS_ITA_VW
43	COMPRATE	Number(19,6)	DECIMAL(18,6) NOT NULL	Compensation Rate
44	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
45	COMP_FREQUENCY	Character(5)	VARCHAR2(5) NOT NULL	Compensation Frequency A=Annual B=Biweekly C=Contract D=Daily H=Hourly M=Monthly S=Semimonthly W=Weekly Prompt Table: FREQUENCY_TBL