REG002_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	SEQ_NUM8	Number(8,0)	INTEGER NOT NULL	Sequence Number
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
5	HIRE_DT	Date(10)	DATE	First Start Date
6	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
7	COUNTRY_DESCR1	Character(30)	VARCHAR2(30) NOT NULL	Country Description
8	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec
9	BIRTHDATE	Date(10)	DATE	Date of Birth
10	JOBCODE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Job Code Description
11	DESCR25	Character(25)	VARCHAR2(25) NOT NULL	Description - Part 1
12	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description
13	ENTRY_DT	Date(10)	DATE	This field pertains to the date a person enters a country on a specific visa.
14	LEAVE_DT	Date(10)	DATE	Leave Date
15	EFFDT	Date(10)	DATE	Effective Date Default Value: %date