HR_JOB_SRC_TMP1

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Default Value: PER_ORG_ASGN.EMPLID Prompt Table: PERS_SRCH_GBL
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
5	PER_ORG	Character(3)	VARCHAR2(3) NOT NULL	Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest. CWR=Contingent Worker EMP=Employee POI=Person of Interest Default Value: PER_ORG_ASGN.PER_ORG
6	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department Set ID Default Value: OPR_DEF_TBL_HR.SETID
7	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPT_TBL
8	SETID_JOBCODE	Character(5)	VARCHAR2(5) NOT NULL	Job Code Set ID Default Value: OPR_DEF_TBL_HR.SETID
9	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code Prompt Table: JOBCODE_TBL
10	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number Prompt Table: POSN_DATA_VW
11	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location Set ID
12	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
13	REG_TEMP	Character(1)	VARCHAR2(1) NOT NULL	Regular/Temporary R=Regular T=Temporary Default Value: R
14	FULL_PART_TIME	Character(1)	VARCHAR2(1) NOT NULL	Full/Part Time D=On Demand F=Full-Time P=Part-Time Default Value: F
15	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT Prompt Table: BUSUNIT_HR_VW
16	REG_REGION	Character(5)	VARCHAR2(5) NOT NULL	Regulatory Region Default Value: OPR_DEF_TBL_HR.REG_REGION Prompt Table: REG_STANDARD_VW
17	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
18	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
19	HR_SRCH_CMP_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Company Descr
20	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group Prompt Table: %EDITTABLE5
21	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
22	PAY_SYSTEM_FLG	Character(2)	VARCHAR2(2) NOT NULL	Payroll System GP=Global Payroll NA=Payroll for North America OT=Other PI=Payroll Interface Default Value: OPR_DEF_TBL_HR.PAY_SYSTEM_FLG
23	HR_SRCH_PYGP_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Paygroup Description
24	HR_SRCH_GPPY_DESCR	Character(30)	VARCHAR2(30) NOT NULL	GP paygroup Description
25	ESTABID	Character(12)	VARCHAR2(12) NOT NULL	Establishment ID Prompt Table: %EDITTABLE3
26	ABSENCE_SYSTEM_CD	Character(3)	VARCHAR2(3) NOT NULL	What Absence System this Assignment is tied to. AM=Absence Management OT=Other Default Value: OT
27	HR_SRCH_GP_XLAT	Character(30)	VARCHAR2(30) NOT NULL	GP paysytem xlatlongname
28	HR_SRCH_ABS_STM_CD	Character(3)	VARCHAR2(3) NOT NULL	SES: Absence system code referenced in HR_SRCH_JOBDATA query
29	HR_SRCH_ABS_XLAT	Character(30)	VARCHAR2(30) NOT NULL	Abs paysytem xlatlongname
30	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. Default Value: %datetime
31	SUPERVISOR_ID	Character(11)	VARCHAR2(11) NOT NULL	Supervisor ID
32	REPORTS_TO	Character(8)	VARCHAR2(8) NOT NULL	Reports To Position Number
33	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action
34	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code
35	HR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	HR Status A=Active I=Inactive
36	EMPL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payroll Status A=Active D=Deceased L=Leave of Absence P=Leave With Pay Q=Retired With Pay R=Retired S=Suspended T=Terminated U=Terminated With Pay V=Terminated Pension Pay Out W=Short Work Break X=Retired-Pension Administration
37	EMPL_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Employee Type E=Exception Hourly H=Hourly N=Not Applicable S=Salaried