VC_AWDALC3_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	ROWSECCLASS	Character(30)	VARCHAR2(30) NOT NULL	The class used to determine row level security
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
5	VC_PLAN_ID	Character(10)	VARCHAR2(10) NOT NULL	VC Plan ID
6	VC_PAYOUT_PRD_ID	Character(10)	VARCHAR2(10) NOT NULL	Payout Period ID
7	GB_GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Group Build ID.
8	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
9	NAME_DISPLAY_SRCH	Character(50)	VARCHAR2(50) NOT NULL	Uppercase version of Name to improve performance on searches.
10	NAME_PSFORMAT	Character(50)	VARCHAR2(50) NOT NULL	A Person's name in the Peoplesoft Format (basically LN,FN MI
11	LAST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Last Name
12	SECOND_LAST_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Second Last Name
13	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
14	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
15	SECOND_LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Second Last Name
16	NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Alternate Character Name
17	MIDDLE_NAME	Character(30)	VARCHAR2(30) NOT NULL	MIDDLE_NAME
18	NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Display Name - name formatted for Display based on the Country
19	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
20	POI_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines the Transactional usage of POIs in HRMS.
21	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
22	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department Set ID Prompt Table: SETID_TBL
23	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: PERS_DEPT_VW
24	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location Set ID
25	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
26	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
27	REG_REGION	Character(5)	VARCHAR2(5) NOT NULL	Regulatory Region
28	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution
29	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID
30	HR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	HR Status A=Active I=Inactive
31	MILITARY_SERVICE	Character(8)	VARCHAR2(8) NOT NULL	Military Service Prompt Table: MIL_SERVICE_TBL
32	MIL_RANK	Character(5)	VARCHAR2(5) NOT NULL	Military Rank Prompt Table: MIL_RANK_TBL
33	MIL_WORN_RANK	Character(5)	VARCHAR2(5) NOT NULL	Worn Rank Prompt Table: MIL_RANK_TBL
34	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
35	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
36	OTHER_ID_JPN	Character(11)	VARCHAR2(11) NOT NULL	Other Identifier
37	FUTURE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Flag for the SJT_*** record that indicates whether this is a future dated row or not. Y = Future N = Current
38	REPORTS_TO	Character(8)	VARCHAR2(8) NOT NULL	Reports To Position Number
39	SUPERVISOR_ID	Character(11)	VARCHAR2(11) NOT NULL	Supervisor ID
40	SETID_JOBCODE	Character(5)	VARCHAR2(5) NOT NULL	Job Code Set ID
41	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code