HRS_DIV_OV_STG1

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HRS_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	Person Id
2	HRS_RCMNT_ID	Number(15,0)	DECIMAL(15) NOT NULL	App Tracking Recruitment ID
3	HRS_PROFILE_SEQ	Number(3,0)	SMALLINT NOT NULL	Profile sequece
4	HRS_DIV_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Field used to list diversity Types. D=Disability E=Ethnicity G=Gender V=Veterans
5	HRS_DESCR90	Character(90)	VARCHAR2(90) NOT NULL	content item description
6	NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Display Name - name formatted for Display based on the Country
7	APP_PER_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Identifies the type of applicant - External Applicant, Employee or Non-Employee A=External Applicant E=Employee N=Non-Employee
8	STATUS_CODE	Character(3)	VARCHAR2(3) NOT NULL	Identifies a status.
9	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
10	ENTRY_DATE	Date(10)	DATE	Date Entered
11	HRS_JOB_OPENING_ID	Number(15,0)	DECIMAL(15) NOT NULL	Job Opening Clone
12	DISABILITY_STS_USA	Character(1)	VARCHAR2(1) NOT NULL	Disability (Section 503) Status USA N=Not Disabled X=Not Indicated Y=Disabled
13	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
14	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown
15	HRS_HR_EFFDT	Date(10)	DATE	HR Record EFFDT
16	MILITARY_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Veteran Status / Military Status
17	DESCR1	Character(30)	VARCHAR2(30) NOT NULL	Descr