JOB_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Default Value: NEW Prompt Table: PERSON
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
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: POSITION_DATA
9	POSITION_OVERRIDE	Character(1)	VARCHAR2(1) NOT NULL	Override Position Data Y/N Table Edit Default Value: N
10	POSN_CHANGE_RECORD	Character(1)	VARCHAR2(1) NOT NULL	Position Management Record Y/N Table Edit Default Value: N
11	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
12	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action Default Value: HIR Prompt Table: ACTION_TBL
13	ACTION_DT	Date(10)	DATE	Action Date Default Value: %date
14	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code Prompt Table: ACTN_REASON_TBL
15	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code Prompt Table: LOCATION_TBL
16	TAX_LOCATION_CD	Character(10)	VARCHAR2(10) NOT NULL	Tax Location Code
17	JOB_ENTRY_DT	Date(10)	DATE	Job Entry Date
18	DEPT_ENTRY_DT	Date(10)	DATE	Department Entry Date
19	POSITION_ENTRY_DT	Date(10)	DATE	Position Entry Date
20	SHIFT	Character(1)	VARCHAR2(1) NOT NULL	Regular Shift 1=1 2=2 3=3 A=Any C=Compressed N=Not Applicable R=Rotating Default Value: N
21	REG_TEMP	Character(1)	VARCHAR2(1) NOT NULL	Regular/Temporary R=Regular T=Temporary Default Value: R
22	FULL_PART_TIME	Character(1)	VARCHAR2(1) NOT NULL	Full/Part Time D=On Demand F=Full-Time P=Part-Time Default Value: F
23	FLSA_STATUS	Character(1)	VARCHAR2(1) NOT NULL	FLSA Status field 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
24	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
25	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
26	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group Prompt Table: PAYGROUP_TBL
27	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.
28	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.
29	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.
30	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.
31	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.
32	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.
33	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.
34	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.
35	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.
36	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.
37	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
38	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.
39	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.
40	EMPL_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Employee Type E=Exception Hourly H=Hourly N=Not Applicable S=Salaried Prompt Table: PAYGRP_EMPLTYPE
41	HOLIDAY_SCHEDULE	Character(6)	VARCHAR2(6) NOT NULL	Holiday Schedule Prompt Table: HOLIDAY_TBL
42	STD_HOURS	Number(7,2)	DECIMAL(6,2) NOT NULL	Standard Hours
43	STD_HRS_FREQUENCY	Character(5)	VARCHAR2(5) NOT NULL	Standard Work Period Prompt Table: STDHRS_FREQ_VW
44	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
45	EMPL_CLASS	Character(3)	VARCHAR2(3) NOT NULL	Employee Classification
46	SAL_ADMIN_PLAN	Character(4)	VARCHAR2(4) NOT NULL	Salary Administration Plan Prompt Table: SAL_PLAN_TBL
47	GRADE	Character(3)	VARCHAR2(3) NOT NULL	Salary Grade Prompt Table: SAL_GRADE_TBL
48	GRADE_ENTRY_DT	Date(10)	DATE	Grade Entry Date
49	STEP	Number(2,0)	SMALLINT NOT NULL	Step Prompt Table: SAL_STEP_TBL
50	STEP_ENTRY_DT	Date(10)	DATE	Step Entry Date
51	GL_PAY_TYPE	Character(6)	VARCHAR2(6) NOT NULL	General Ledger Pay Type
52	ACCT_CD	Character(25)	VARCHAR2(25) NOT NULL	Combination Code Prompt Table: ACCT_CD_TBL
53	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
54	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
55	COMPRATE	Number(19,6)	DECIMAL(18,6) NOT NULL	Compensation Rate
56	CHANGE_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Change Amount
57	CHANGE_PCT	Signed Number(8,3)	DECIMAL(6,3) NOT NULL	Change Percent
58	ANNUAL_RT	Number(19,3)	DECIMAL(18,3) NOT NULL	Annual Rate
59	MONTHLY_RT	Number(19,3)	DECIMAL(18,3) NOT NULL	Monthly Rate
60	DAILY_RT	Number(19,3)	DECIMAL(18,3) NOT NULL	Daily Rate
61	HOURLY_RT	Number(19,6)	DECIMAL(18,6) NOT NULL	Hourly Rate
62	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.
63	SHIFT_RT	Number(19,6)	DECIMAL(18,6) NOT NULL	Shift Differential Rate
64	SHIFT_FACTOR	Number(5,3)	DECIMAL(4,3) NOT NULL	Shift Differential Factor
65	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY Prompt Table: CURRENCY_CD_TBL
66	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT Prompt Table: BUS_UNIT_TBL_HR
67	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department SetID Default Value: OPR_DEF_TBL_HR.SETID
68	SETID_JOBCODE	Character(5)	VARCHAR2(5) NOT NULL	Job Code SetID Default Value: OPR_DEF_TBL_HR.SETID
69	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location SetID
70	SETID_SALARY	Character(5)	VARCHAR2(5) NOT NULL	Salary SetID
71	FUNCTION_CD	Character(2)	VARCHAR2(2) NOT NULL	Function Code
72	HOURLY_RT_FRA	Character(3)	VARCHAR2(3) NOT NULL	Hours Type
73	ACCDNT_CD_FRA	Character(1)	VARCHAR2(1) NOT NULL	Work Accident Type Code 0=Do not Pay 1=Building 2=Waterproofing 3=Floor Surface 4=Factory Making 5=Laboratory 6=WorkShop 7=Office
74	ESTABID	Character(12)	VARCHAR2(12) NOT NULL	Establishment ID
75	REG_REGION	Character(5)	VARCHAR2(5) NOT NULL	Regulatory Region Default Value: OPR_DEF_TBL_HR.REG_REGION
76	DIRECTLY_TIPPED	Character(1)	VARCHAR2(1) NOT NULL	Tipped D=Directly Tipped I=Indirectly Tipped N=Not Tipped Default Value: JOBCODE_TBL.DIRECTLY_TIPPED
77	ADDS_TO_FTE_ACTUAL	Character(1)	VARCHAR2(1) NOT NULL	Adds to FTE Actual Count Y/N Table Edit Default Value: N
78	CLASS_INDC	Character(1)	VARCHAR2(1) NOT NULL	Classified/Unclassified Indc B=All C=Classified T=Temporary U=Unclassified Default Value: C
79	FICA_STATUS_EE	Character(1)	VARCHAR2(1) NOT NULL	FICA Status-Employee E=Exempt H=ER FICA Exmpt M=Medicare only N=Subject
80	FTE	Number(8,6)	DECIMAL(7,6) NOT NULL	This field represent Full Time Equivalence
81	PRORATE_CNT_AMT	Character(1)	VARCHAR2(1) NOT NULL	Prorate Contract Change Amount C=Prorate Over Contract Period N=No Proration of Change Amt. P=Prorate over Payment Period Default Value: N
82	ENCUMB_OVERRIDE	Character(1)	VARCHAR2(1) NOT NULL	Encumbrance Override Default Value: N
83	UNION_FULL_PART	Character(1)	VARCHAR2(1) NOT NULL	Union Participation F=Full Time P=Part Time
84	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.
85	PAY_UNION_FEE	Character(1)	VARCHAR2(1) NOT NULL	Pay Union Fee
86	UNION_CD	Character(3)	VARCHAR2(3) NOT NULL	Union Code
87	BARG_UNIT	Character(4)	VARCHAR2(4) NOT NULL	Bargaining Unit 1=Bargaining Unit 1 2=Bargaining Unit 2 Prompt Table: GVT_BARG_UNIT
88	UNION_SENIORITY_DT	Date(10)	DATE	Union Seniority Date
89	VALUE_1_FRA	Character(5)	VARCHAR2(5) NOT NULL	Value 1
90	VALUE_2_FRA	Character(5)	VARCHAR2(5) NOT NULL	Value 2
91	VALUE_3_FRA	Character(5)	VARCHAR2(5) NOT NULL	Value 3
92	VALUE_4_FRA	Character(5)	VARCHAR2(5) NOT NULL	Value 4
93	VALUE_5_FRA	Character(5)	VARCHAR2(5) NOT NULL	Value 5
94	CTG_RATE	Number(3,0)	SMALLINT NOT NULL	Category Rate
95	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
96	TARIFF_AREA_GER	Character(3)	VARCHAR2(3) NOT NULL	Tariff Area
97	PERFORM_GROUP_GER	Character(2)	VARCHAR2(2) NOT NULL	Performance Group 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
98	LABOR_TYPE_GER	Character(1)	VARCHAR2(1) NOT NULL	Labor Type M=Management N=Non-Management
99	SPK_COMM_ID_GER	Character(9)	VARCHAR2(9) NOT NULL	Spokesmen Committee ID
100	ENTRY_DATE	Date(10)	DATE	Date Entered
101	LABOR_AGREEMENT	Character(6)	VARCHAR2(6) NOT NULL	Labor Agreement
102	EMPL_CTG	Character(6)	VARCHAR2(6) NOT NULL	Employee Category
103	EMPL_CTG_L1	Character(6)	VARCHAR2(6) NOT NULL	Employee Subcategory
104	EMPL_CTG_L2	Character(6)	VARCHAR2(6) NOT NULL	Employee Subcategory 2
105	SETID_LBR_AGRMNT	Character(5)	VARCHAR2(5) NOT NULL	Labor Agreement SetID
106	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
107	BORDER_WALKER	Character(1)	VARCHAR2(1) NOT NULL	Cross Border Worker
108	LUMP_SUM_PAY	Character(1)	VARCHAR2(1) NOT NULL	Lump Sum Retro Payment Y/N Table Edit Default Value: N
109	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract Number
110	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
111	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
112	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)
113	GP_ELIG_GRP	Character(10)	VARCHAR2(10) NOT NULL	Eligibility Group
114	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)
115	CUR_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type
116	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)
117	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
118	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
119	WRKS_CNCL_ROLE_CHE	Character(30)	VARCHAR2(30) NOT NULL	Work Council Role
120	EXEMPT_HOURS_MONTH	Number(3,0)	SMALLINT NOT NULL	Exempted Hours per Month
121	EXEMPT_JOB_LBR	Character(1)	VARCHAR2(1) NOT NULL	Exempted
122	INTERCTR_WRKS_CNCL	Character(1)	VARCHAR2(1) NOT NULL	InterCtr.Works Cnil Function 1=Member 1 2=Member 2 3=Member 3
123	CURRENCY_CD1	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
124	MATRICULA_NBR	Number(5,0)	INTEGER NOT NULL	Matricula Number
125	SOC_SEC_RISK_CODE	Character(3)	VARCHAR2(3) NOT NULL	Occupation Code
126	UNION_FEE_AMOUNT	Number(9,2)	DECIMAL(8,2) NOT NULL	Union Fee Amount
127	UNION_FEE_END_DT	Date(10)	DATE	Union Fee End Date
128	UNION_FEE_START_DT	Date(10)	DATE	Union Fee Start Date
129	WRKS_CNCL_FUNCTION	Character(1)	VARCHAR2(1) NOT NULL	Works Council Function M=Member P=President S=Secretary
130	PAID_HOURS	Number(7,2)	DECIMAL(6,2) NOT NULL	Paid Hours
131	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.
132	PAID_HRS_FREQUENCY	Character(5)	VARCHAR2(5) NOT NULL	Paid Work Period
133	WORK_DAY_HOURS	Number(7,2)	DECIMAL(6,2) NOT NULL	Number of Hours in a Work Day
134	SUPERVISOR_ID	Character(11)	VARCHAR2(11) NOT NULL	Supervisor ID
135	REPORTS_TO	Character(8)	VARCHAR2(8) NOT NULL	Reports To Position Number
136	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.
137	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