BEN_SRCH_JD_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	BENEFIT_RCD_NBR	Number(3,0)	SMALLINT NOT NULL	Specifies a sequence number associated with each of multiple concurrent jobs for a one employee. It is used to determine the applicable benefit program for each job. The first job entered for an employee is automatically assigned a Benefit Record Number of zero (0). This field is linked with EMPL_RCD#, the Employment Record Number.
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
4	BENEFIT_PROGRAM	Character(3)	VARCHAR2(3) NOT NULL	Defines a collection of benefit plans and their associated rate and calculation rules.
5	BENEFIT_PGM_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Benefit Program description
6	NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Display Name - name formatted for Display based on the Country
7	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown
8	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
9	BUSINESS_DESCR	Character(60)	VARCHAR2(60) NOT NULL	Business Description
10	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department Set ID
11	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
12	DEPT_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Department Description
13	SETID_JOBCODE	Character(5)	VARCHAR2(5) NOT NULL	Job Code Set ID
14	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
15	JOBCODE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Job Code Description
16	REG_TEMP	Character(1)	VARCHAR2(1) NOT NULL	Regular/Temporary R=Regular T=Temporary
17	FULL_PART_TIME	Character(1)	VARCHAR2(1) NOT NULL	Full/Part Time D=On Demand F=Full-Time P=Part-Time
18	EMPL_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Employee Type E=Exception Hourly H=Hourly N=Not Applicable S=Salaried
19	REG_REGION	Character(5)	VARCHAR2(5) NOT NULL	Regulatory Region
20	BIRTHDATE	Date(10)	DATE	Date of Birth
21	AGE	Number(3,0)	SMALLINT NOT NULL	Age
22	AGE_DESCR	Character(100)	VARCHAR2(100) NOT NULL	Description for Diversity Types (Age, Ethnic Disability, Ethnic Group, Gender, and Veteran Status).
23	BEN_AGE_RANGE	Character(1)	VARCHAR2(1) NOT NULL	Age Range 1=<18 2=18-24 3=25-34 4=35-44 5=45-54 6=55-64 7=65+ N=Not Available
24	GENDER_DESCR	Character(100)	VARCHAR2(100) NOT NULL	Description for Diversity Types (Age, Ethnic Disability, Ethnic Group, Gender, and Veteran Status).
25	ETHNIC_GRP_DESCR	Character(100)	VARCHAR2(100) NOT NULL	Description for Diversity Types (Age, Ethnic Disability, Ethnic Group, Gender, and Veteran Status).
26	EMPL_TYPE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Employee Type
27	REG_REGION_DESCR	Character(50)	VARCHAR2(50) NOT NULL	Regulatory Region
28	ETHNIC_GROUP	Character(1)	VARCHAR2(1) NOT NULL	Ethnic Group 1=White 2=Black/African American 3=Hispanic/Latino 4=Asian 5=American Indian/Alaska Native 6=Not Applicable 7=Native Hawaiian/Oth Pac Island A=American Indian/Alaskan Native B=Asian or Pacific Islander C=Black, not of Hispanic origin D=Hispanic E=White, not of Hispanic origin F=Asian Indian G=Chinese H=Filipino J=Guamanian K=Hawaiian L=Japanese M=Korean N=Samoan P=Vietnamese Q=All Other Asian o Pacific Is Y=Not Hispanic in Puerto Rico
29	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location Set ID
30	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
31	LOCATION_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Location Description
32	JOB_FAMILY	Character(6)	VARCHAR2(6) NOT NULL	Job Family
33	JOB_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Job Description
34	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
35	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
36	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
37	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
38	FULLPART_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Full and Part Time Descr
39	REGTEMP_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Regular Temp description