EP_SRCH_JOB_VW

#	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	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPT_TBL
7	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code Prompt Table: JOBCODE_TBL
8	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number Prompt Table: POSN_DATA_VW
9	SUPERVISOR_ID	Character(11)	VARCHAR2(11) NOT NULL	Supervisor ID Prompt Table: HCR_SUP_ID_DVW
10	HR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	HR Status A=Active I=Inactive Default Value: A
11	APPT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	This field tracks whether a row is a Main Appointment (which all rows outside Japan are), or an Additional Appointment, which is a feature only used by Japanese customers. 0=Core Appointment 1=Japan Kenmu Appointment 2=French Public Sector Appt 3=Staffing Default Value: 0
12	MAIN_APPT_NUM_JPN	Number(3,0)	SMALLINT NOT NULL	Tracks the empl_rcd for the Main Appointment of this row. For a Main Appointment, this field stores the same value as the current empl_rcd, for an Additional Appointment, it stores the value of a different empl_rcd.
13	POSITION_OVERRIDE	Character(1)	VARCHAR2(1) NOT NULL	Override Position Data Y/N Table Edit Default Value: N
14	POSN_CHANGE_RECORD	Character(1)	VARCHAR2(1) NOT NULL	Position Management Record Y/N Table Edit Default Value: N
15	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 Default Value: A
16	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action Prompt Table: ACTION_TBL
17	ACTION_DT	Date(10)	DATE	Action Date Default Value: %date
18	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code Prompt Table: ACTN_REASON_TBL
19	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code Prompt Table: LOCATION_TBL
20	TAX_LOCATION_CD	Character(10)	VARCHAR2(10) NOT NULL	Tax Location Code Prompt Table: %RECNAME_EDIT
21	JOB_ENTRY_DT	Date(10)	DATE	Job Entry Date
22	DEPT_ENTRY_DT	Date(10)	DATE	Department Entry Date
23	POSITION_ENTRY_DT	Date(10)	DATE	Position Entry Date
24	SHIFT	Character(1)	VARCHAR2(1) NOT NULL	Regular Shift 1=Day 2=Evening 3=Night A=Any C=Compressed N=Not Applicable R=Rotating Default Value: N
25	REG_TEMP	Character(1)	VARCHAR2(1) NOT NULL	Regular/Temporary R=Regular T=Temporary Default Value: R
26	FULL_PART_TIME	Character(1)	VARCHAR2(1) NOT NULL	Full/Part Time D=On Demand F=Full-Time P=Part-Time Default Value: F
27	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
28	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group Prompt Table: %EDITTABLE5
29	BAS_GROUP_ID	Character(3)	VARCHAR2(3) NOT NULL	Identifies a user-defined Benefits Administration group used to facilitate benefits processing. A group can represent the entire participant population of the enterprise, or a specific group of participants. It enables you to control processing by, for example, setting up separate Open Enrollment schedules for each group. If used, a BAS Group ID is assigned to each participant in a benefit program. Prompt Table: BAS_GROUP_TBL
30	ELIG_CONFIG1	Character(10)	VARCHAR2(10) NOT NULL	This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
31	ELIG_CONFIG2	Character(10)	VARCHAR2(10) NOT NULL	This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
32	ELIG_CONFIG3	Character(10)	VARCHAR2(10) NOT NULL	This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
33	ELIG_CONFIG4	Character(10)	VARCHAR2(10) NOT NULL	This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
34	ELIG_CONFIG5	Character(10)	VARCHAR2(10) NOT NULL	This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
35	ELIG_CONFIG6	Character(10)	VARCHAR2(10) NOT NULL	This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
36	ELIG_CONFIG7	Character(10)	VARCHAR2(10) NOT NULL	This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
37	ELIG_CONFIG8	Character(10)	VARCHAR2(10) NOT NULL	This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
38	ELIG_CONFIG9	Character(10)	VARCHAR2(10) NOT NULL	This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
39	BEN_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Specifies an employee's status relative to benefits, and is used to determine eligibility for benefits. Some examples of benefit status are Active, Suspended, Leave with Benefits, and Terminated. A=Active D=Deceased L=Leave of Absence P=Leave With Benefits Q=Retired With Benefits R=Retired S=Suspended T=Terminated U=Terminated With Benefits
40	BAS_ACTION	Character(3)	VARCHAR2(3) NOT NULL	Identifies a benefits-related process or event that is associated with a personnel action action reason combination. This provides the link between various personnel changes (both job-related and personal) and benefits eligibility. A BAS (PeopleSoft Benefits Administration System) action may correspond to a BAS Event Class, which defines how a benefits-related event is recognized and handled. Some examples of BAS actions (and event classes) are Hire, Family Status Change, and Open Enrollment.
41	COBRA_ACTION	Character(3)	VARCHAR2(3) NOT NULL	Identifies a COBRA-related process or event that is associated with a personnel action action reason combination. This provides the link between various personnel changes (both job-related and personal) and COBRA benefits eligibility. A COBRA action may correspond to a COBRA event classification, which defines how a qualifying event is recognized and handled. Some examples of COBRA actions (and qualifying events) are Death, Divorce, Medicare, and Military Leave. U.S. only.
42	EMPL_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Employee Type E=Exception Hourly H=Hourly N=Not Applicable S=Salaried Prompt Table: PYGRP_EMPTYP_VW
43	HOLIDAY_SCHEDULE	Character(6)	VARCHAR2(6) NOT NULL	Holiday Schedule Prompt Table: HOLIDAY_VW
44	STD_HOURS	Number(7,2)	DECIMAL(6,2) NOT NULL	Standard Hours
45	STD_HRS_FREQUENCY	Character(5)	VARCHAR2(5) NOT NULL	Standard Work Period Prompt Table: STDHRS_FREQ_VW
46	OFFICER_CD	Character(1)	VARCHAR2(1) NOT NULL	Officer Code C=Chairman D=Director N=None O=Officer P=President S=Secretary T=Treasurer V=Vice President Default Value: N
47	EMPL_CLASS	Character(3)	VARCHAR2(3) NOT NULL	Employee Classification Prompt Table: EMPL_CLASS_TBL Set Control Field: REG_REGION
48	SAL_ADMIN_PLAN	Character(4)	VARCHAR2(4) NOT NULL	Salary Administration Plan Prompt Table: %EDITTABLE7
49	GRADE	Character(3)	VARCHAR2(3) NOT NULL	Salary Grade Prompt Table: %EDITTABLE8
50	GRADE_ENTRY_DT	Date(10)	DATE	Grade Entry Date
51	STEP	Number(2,0)	SMALLINT NOT NULL	Step Prompt Table: %EDITTABLE9
52	STEP_ENTRY_DT	Date(10)	DATE	Step Entry Date
53	GL_PAY_TYPE	Character(6)	VARCHAR2(6) NOT NULL	General Ledger Pay Type
54	ACCT_CD	Character(25)	VARCHAR2(25) NOT NULL	Combination Code Prompt Table: %EDITTABLE2
55	EARNS_DIST_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Earnings Distribution Type A=By Amount H=By Hours N=None P=By Percent Default Value: N
56	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 Default Value: INSTALLATION.COMP_FREQUENCY Prompt Table: COMP_FREQ_VW
57	COMPRATE	Number(19,6)	DECIMAL(18,6) NOT NULL	Compensation Rate
58	CHANGE_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Change Amount
59	CHANGE_PCT	Signed Number(8,3)	DECIMAL(6,3) NOT NULL	Change Percent
60	ANNUAL_RT	Number(19,3)	DECIMAL(18,3) NOT NULL	Annual Rate
61	MONTHLY_RT	Number(19,3)	DECIMAL(18,3) NOT NULL	Monthly Rate
62	DAILY_RT	Number(19,3)	DECIMAL(18,3) NOT NULL	Daily Rate
63	HOURLY_RT	Number(19,6)	DECIMAL(18,6) NOT NULL	Hourly Rate
64	ANNL_BENEF_BASE_RT	Number(19,3)	DECIMAL(18,3) NOT NULL	Specifies a compensation amount used to calculate benefits and benefit deductions for an employee. The base compensation amount may include commissions and bonuses in addition to regular compensation. If no Annual Benefits Base Rate is entered, then benefits calculations are based on an employee's regular compensation.
65	SHIFT_RT	Number(19,6)	DECIMAL(18,6) NOT NULL	Shift Differential Rate
66	SHIFT_FACTOR	Number(5,3)	DECIMAL(4,3) NOT NULL	Shift Differential Factor
67	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY Prompt Table: CURRENCY_CD_TBL
68	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT Prompt Table: BUSUNIT_HR_VW
69	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department Set ID Default Value: OPR_DEF_TBL_HR.SETID
70	SETID_JOBCODE	Character(5)	VARCHAR2(5) NOT NULL	Job Code Set ID Default Value: OPR_DEF_TBL_HR.SETID
71	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location Set ID
72	SETID_SALARY	Character(5)	VARCHAR2(5) NOT NULL	Salary Set ID
73	SETID_EMPL_CLASS	Character(5)	VARCHAR2(5) NOT NULL	Employee class Set ID Default Value: EMPL_CLASS_TBL.SETID
74	REG_REGION	Character(5)	VARCHAR2(5) NOT NULL	Regulatory Region Default Value: OPR_DEF_TBL_HR.REG_REGION Prompt Table: REG_STANDARD_VW
75	DIRECTLY_TIPPED	Character(1)	VARCHAR2(1) NOT NULL	Tipped D=Directly Tipped I=Indirectly Tipped N=Not Tipped Default Value: JOBCODE_TBL.DIRECTLY_TIPPED
76	FLSA_STATUS	Character(1)	VARCHAR2(1) NOT NULL	FLSA Status A=Administrative C=Computer Employee E=Executive H=Highly Compensated Employees M=Management N=Nonexempt O=Outside Salesperson P=Professional V=Nonexempt Alt Overtime X=No FLSA Required Default Value: X
77	EEO_CLASS	Character(1)	VARCHAR2(1) NOT NULL	EEO Classification E=Exclude from Count N=None of the Above P=Production Trainee W=White-Collar Trainee Default Value: N
78	FUNCTION_CD	Character(2)	VARCHAR2(2) NOT NULL	Function Code Prompt Table: FUNCTION_CD_TBL
79	TARIFF_GER	Character(2)	VARCHAR2(2) NOT NULL	Tariff 01=Metal Processing 02=Banking 03=Building and Civil Engineering 04=Clothing Industry 05=Chemical Industry 06=Printing Industry 07=Retail Trade 08=Fossil Oil and Gas Extraction 09=Glass Industry 10=Wholesale and Foreign Trade 11=Wood Processing 12=Rubber Processing 13=Ceramics 14=Agriculture 15=Leather Processing 16=Public Sector 17=Paper Industry 18=Paper Processing 19=Sawing Industry 20=German Seaports 21=Hard-Coal Mining 22=Textile Industry 23=Insurance 24=Housing Industry 25=Periodical Publishers 26=Newspaper Publishers 27=Tobacco Industry
80	TARIFF_AREA_GER	Character(3)	VARCHAR2(3) NOT NULL	Tariff Area Prompt Table: TARIFF_AREA_GER
81	PERFORM_GROUP_GER	Character(2)	VARCHAR2(2) NOT NULL	This field is used for German employees to track the Performance Group associated to the Job Labor agreement. A1=Blue Collar Performance Grp. 1 A2=Blue Collar Performance Grp. 2 A3=Blue Collar Performance Grp. 3 K1=Commercial White Collar Grp. 1 K2=Commercial White Collar Grp. 2 K3=Commercial White Collar Grp. 3 K4=Commercial White Collar Grp. 4 K5=Commerical White Collar Grp. 5 T1=Technical White Collar Grp. 1 T2=Technical White Collar Grp. 2 T3=Technical White Collar Grp. 3 T4=Technical White Collar Grp. 4 T5=Technical White Collar Grp. 5
82	LABOR_TYPE_GER	Character(1)	VARCHAR2(1) NOT NULL	Field to track whether a Job is a management or non-management position. M=Management N=Non-Management
83	SPK_COMM_ID_GER	Character(9)	VARCHAR2(9) NOT NULL	Spokesmen Committee ID Prompt Table: SPK_COMM_GER
84	HOURLY_RT_FRA	Character(3)	VARCHAR2(3) NOT NULL	HFR Prompt Table: HOURS_TYPE_FRA
85	ACCDNT_CD_FRA	Character(1)	VARCHAR2(1) NOT NULL	HFR 0=Do not Pay 1=Building 2=Waterproofing 3=Floor Surface 4=Factory Making 5=Laboratory 6=WorkShop 7=Office
86	VALUE_1_FRA	Character(5)	VARCHAR2(5) NOT NULL	HFR
87	VALUE_2_FRA	Character(5)	VARCHAR2(5) NOT NULL	HFR
88	VALUE_3_FRA	Character(5)	VARCHAR2(5) NOT NULL	HCR
89	VALUE_4_FRA	Character(5)	VARCHAR2(5) NOT NULL	HFR
90	VALUE_5_FRA	Character(5)	VARCHAR2(5) NOT NULL	HFR
91	CTG_RATE	Number(3,0)	SMALLINT NOT NULL	Category Rate
92	PAID_HOURS	Number(7,2)	DECIMAL(6,2) NOT NULL	Paid Hours
93	PAID_FTE	Number(8,6)	DECIMAL(7,6) NOT NULL	This field is si;ilqr to JOB.FTE field however it is computed with PAID_HOURS instead of STD_HOURS. It is a French specific field.
94	PAID_HRS_FREQUENCY	Character(5)	VARCHAR2(5) NOT NULL	Paid Work Period Prompt Table: STDHRS_FREQ_VW
95	UNION_FULL_PART	Character(1)	VARCHAR2(1) NOT NULL	Union Participation F=Full Time P=Part Time
96	UNION_POS	Character(1)	VARCHAR2(1) NOT NULL	Union Position L=Leader of the union N=National Leader R=Registered S=Leader of S.O.C.
97	MATRICULA_NBR	Number(5,0)	INTEGER NOT NULL	Matricula Number
98	SOC_SEC_RISK_CODE	Character(3)	VARCHAR2(3) NOT NULL	Social Security Risk Code Prompt Table: %EDITTABLE12
99	UNION_FEE_AMOUNT	Number(9,2)	DECIMAL(8,2) NOT NULL	Union Fee Amount
100	UNION_FEE_START_DT	Date(10)	DATE	Union Fee Start Date
101	UNION_FEE_END_DT	Date(10)	DATE	Union Fee End Date
102	EXEMPT_JOB_LBR	Character(1)	VARCHAR2(1) NOT NULL	Exempted Y/N Table Edit Default Value: N
103	EXEMPT_HOURS_MONTH	Number(3,0)	SMALLINT NOT NULL	Exempted Hours per Month
104	WRKS_CNCL_FUNCTION	Character(1)	VARCHAR2(1) NOT NULL	Works Council Function M=Member P=President S=Secretary
105	INTERCTR_WRKS_CNCL	Character(1)	VARCHAR2(1) NOT NULL	InterCtr.Works Council Function 1=Member 1 2=Member 2 3=Member 3
106	CURRENCY_CD1	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
107	PAY_UNION_FEE	Character(1)	VARCHAR2(1) NOT NULL	Pay Union Fee Y/N Table Edit Default Value: N
108	UNION_CD	Character(3)	VARCHAR2(3) NOT NULL	Union Code Prompt Table: UNION_TBL
109	BARG_UNIT	Character(4)	VARCHAR2(4) NOT NULL	Bargaining Unit 1=Bargaining Unit 1 2=Bargaining Unit 2 Prompt Table: HR_BARG_UNIT
110	UNION_SENIORITY_DT	Date(10)	DATE	Union Seniority Date
111	ENTRY_DATE	Date(10)	DATE	Date Entered
112	LABOR_AGREEMENT	Character(6)	VARCHAR2(6) NOT NULL	Labor Agreement Prompt Table: HR_LABOR_AGRMNT
113	EMPL_CTG	Character(6)	VARCHAR2(6) NOT NULL	Employee Category Prompt Table: EMPL_CTG_L1_VW
114	EMPL_CTG_L1	Character(6)	VARCHAR2(6) NOT NULL	Employee Subcategory Prompt Table: EMPL_CTG_L2_VW
115	EMPL_CTG_L2	Character(6)	VARCHAR2(6) NOT NULL	Employee Subcategory 2 Prompt Table: EMPL_CTG_L3_VW
116	SETID_LBR_AGRMNT	Character(5)	VARCHAR2(5) NOT NULL	Labor Agreement SetID
117	WPP_STOP_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Y/N Flag to indicated that Wage Progression is stopped on this Assignment. Y/N Table Edit Default Value: N
118	LABOR_FACILITY_ID	Character(10)	VARCHAR2(10) NOT NULL	Labor Facility ID Prompt Table: HR_LBR_FAC_VW
119	LBR_FAC_ENTRY_DT	Date(10)	DATE	Date the Person was added to this Labor Facility.
120	LAYOFF_EXEMPT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Y/N Flag to indicate if a Person's Assignment is exempt from Layoff. Y/N Table Edit Default Value: N
121	LAYOFF_EXEMPT_RSN	Character(11)	VARCHAR2(11) NOT NULL	Reason for the Exemption from Layoff Prompt Table: HR_LAY_EXEM_TBL
122	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group Prompt Table: %EDITTABLE6
123	GP_DFLT_ELIG_GRP	Character(1)	VARCHAR2(1) NOT NULL	Y/N assign default value from Pay Group (as opposed to assigning value at the payee / job level) Y/N Table Edit Default Value: Y
124	GP_ELIG_GRP	Character(10)	VARCHAR2(10) NOT NULL	Eligibility Group Prompt Table: GP_ELIG_GRP
125	GP_DFLT_CURRTTYP	Character(1)	VARCHAR2(1) NOT NULL	Y/N assign default value from Pay Group (as opposed to assigning value at the payee / job level) Y/N Table Edit Default Value: Y
126	CUR_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type Prompt Table: RT_TYPE_TBL
127	GP_DFLT_EXRTDT	Character(1)	VARCHAR2(1) NOT NULL	Y/N assign default value from Pay Group (as opposed to assigning value at the payee / job level) Y/N Table Edit Default Value: Y
128	GP_ASOF_DT_EXG_RT	Character(1)	VARCHAR2(1) NOT NULL	This field is used as a flag to determine whether to use a default exchange rate or not. B=Pay Period Begin Date E=Pay Period End Date P=Payment Date
129	ADDS_TO_FTE_ACTUAL	Character(1)	VARCHAR2(1) NOT NULL	Adds to FTE Actual Count Y/N Table Edit Default Value: N
130	CLASS_INDC	Character(1)	VARCHAR2(1) NOT NULL	Classified/Unclassified Ind B=All C=Classified T=Temporary U=Unclassified Default Value: C
131	ENCUMB_OVERRIDE	Character(1)	VARCHAR2(1) NOT NULL	Encumbrance Override Y/N Table Edit Default Value: N
132	FICA_STATUS_EE	Character(1)	VARCHAR2(1) NOT NULL	FICA Status-Employee E=Exempt H=ER FICA Exmpt J=EE FICA Exmpt K=EE/ER FICA Exmpt M=Medicare only N=Subject
133	FTE	Number(8,6)	DECIMAL(7,6) NOT NULL	This field represent Full Time Equivalence
134	PRORATE_CNT_AMT	Character(1)	VARCHAR2(1) NOT NULL	Prorate Contract Change Amount C=Prorate Over Contract Period E=Prorate Using Effective Date N=No Proration of Change Amt. P=Prorate Over Payment Period Default Value: N
135	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
136	BORDER_WALKER	Character(1)	VARCHAR2(1) NOT NULL	Cross Border Worker Y/N Table Edit Default Value: N
137	LUMP_SUM_PAY	Character(1)	VARCHAR2(1) NOT NULL	Lump Sum Retro Payment Y/N Table Edit Default Value: N
138	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract Number Prompt Table: CNT_ACTIVE_VW
139	JOB_INDICATOR	Character(1)	VARCHAR2(1) NOT NULL	This Indicator is used on JOB to specify which employment record is considered to be the primary one for an employee. In case of Multiple Jobs per Employee, this property is being used to make a conscious decision in related features where only 1 Employment Record per Employee needs to be returned. N=Not Applicable P=Primary Job S=Secondary Job Default Value: P
140	WRKS_CNCL_ROLE_CHE	Character(30)	VARCHAR2(30) NOT NULL	Use this field to track the Works Council role for Swiss employments.
141	BENEFIT_SYSTEM	Character(2)	VARCHAR2(2) NOT NULL	A flag that indicates whether the benefits for an employee are administered under PeopleSoft Benefits Administration or PeopleSoft Base Benefits. BA=Benefits Administration BN=Base Benefits OT=Not Managed in PeopleSoft
142	WORK_DAY_HOURS	Number(7,2)	DECIMAL(6,2) NOT NULL	Number of Hours in a Work Day
143	REPORTS_TO	Character(8)	VARCHAR2(8) NOT NULL	Reports To Position Number Prompt Table: POSITION_DATA
144	FORCE_PUBLISH	Date(10)	DATE	Used to Force a publish on a row of data that wouldn't otherwise have been changed. This field is a system field only and will not appear on any Page so it does not need to be translated.
145	JOB_DATA_SRC_CD	Character(3)	VARCHAR2(3) NOT NULL	This field indicates the source of a job row ie. whether the job row was User Generated (ie. online), Batch Generated, Staff Movement generated, etc. A blank in this field implies that the job row is user generated. 000=User Generated 001=Batch Generated 002=Staff Movement Generated
146	ESTABID	Character(12)	VARCHAR2(12) NOT NULL	Establishment ID Prompt Table: %EDITTABLE3
147	SUPV_LVL_ID	Character(8)	VARCHAR2(8) NOT NULL	Supervisor Level ID for use in capability grade system Prompt Table: SUPVSR_LVL_TBL
148	SETID_SUPV_LVL	Character(5)	VARCHAR2(5) NOT NULL	Stored setid for the Supervisor Level.
149	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
150	POI_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines the Transactional usage of POIs in HRMS.
151	HIRE_DT	Date(10)	DATE	First Start Date
152	LAST_HIRE_DT	Date(10)	DATE	Latest Start Date - The latest time that an Employee or a Contingent Worker has started - based on EMPLID/EMPL_RCD.
153	TERMINATION_DT	Date(10)	DATE	Termination Date
154	ASGN_START_DT	Date(10)	DATE	Start date of the specific EMPL_RCD assignment. This is different from the Person's Hire date.
155	LST_ASGN_START_DT	Date(10)	DATE	Lastest start date of the specific EMPL_RCD assignment. This is different from the Person's organizational instance Last Hire Date.
156	ASGN_END_DT	Date(10)	DATE	End date of the specific EMPL_RCD assignment. This is different from the Person's Termination date.
157	LDW_OVR	Character(1)	VARCHAR2(1) NOT NULL	Used to indicate whether the user has overridden the Last Date Worked - ON THIS JOB_DATES row. It will only be set to 'Y' on the row where the date is entered, it will be 'N' on the later rows. This allows us to identify which JOB_DATES row is the row where the Date was either set or updated without having to look at the previous row. If the LDW = ( EFFDT - 1 ) or the LDW_OVR is 'Y', then this is the row where the LDW was set - and therefore can be corrected. Y/N Table Edit Default Value: N
158	LAST_DATE_WORKED	Date(10)	DATE	Last Date Worked
159	EXPECTED_RETURN_DT	Date(10)	DATE	Expected Return Date
160	EXPECTED_END_DATE	Date(10)	DATE	Expected End Date of a job.
161	AUTO_END_FLG	Character(1)	VARCHAR2(1) NOT NULL	This field is on the Job page and it allows the users to indicate whether they want the system to automatically end this job on the Expected End Date of the job. This field is dependent on the Expected End Date having a value. Y/N Table Edit Default Value: N
162	COMPA_RATIO	Number(4,2)	DECIMAL(3,2) NOT NULL	Compa-Ratio
163	EP_BU_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Business Unit
164	EP_DEPT_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Department
165	EP_JOBCODE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Job Title
166	EP_COMPANY_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Company
167	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
168	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.