HGA_MANO_NRP_AD

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GP_PKG_ID	Character(10)	VARCHAR2(10) NOT NULL	Field used for element packaging
2	OPERATOR	Character(30)	VARCHAR2(30) NOT NULL	User ID
3	COMPONENT_ID	Character(18)	VARCHAR2(18) NOT NULL	04/10/00 (Internet Architecture) SCC: Uppercase label Id.
4	HGA_SEARCH_OPTION	Character(3)	VARCHAR2(3) NOT NULL	Search option APV=Approved CAN=Cancelled DNY=Denied IAP=In Approval Process PND=My Pendings PSH=Pushed Back SAV=Saved SUB=Submitted VOI=Voided
5	PIN_TK_NUM	Number(8,0)	INTEGER NOT NULL	Element number field
6	APPROVER_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Approver Oper ID
7	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
8	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
9	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
10	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
11	HR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	HR Status A=Active I=Inactive
12	EMPLID_START	Character(11)	VARCHAR2(11) NOT NULL	Payee ID1
13	EMPLID_END	Character(11)	VARCHAR2(11) NOT NULL	Payee ID1
14	LASTNAME_FROM	Character(15)	VARCHAR2(15) NOT NULL	Last Name FROM
15	LASTNAME_TO	Character(15)	VARCHAR2(15) NOT NULL	Last Name TO
16	DATE_FROM	Date(10)	DATE	Date From
17	DATE_TO	Date(10)	DATE	Previous Period Date To
18	ABS_BEGIN_DT_01	Date(10)	DATE	Absence Begin Date 01
19	ABS_BEGIN_DT_02	Date(10)	DATE	Absence Begin Date 02
20	ABS_BEGIN_DT_03	Date(10)	DATE	Absence Begin Date 03
21	ABS_BEGIN_DT_04	Date(10)	DATE	Absence Begin Date 04
22	ABS_BEGIN_DT_05	Date(10)	DATE	Absence Begin Date 05
23	ABS_BEGIN_DT_06	Date(10)	DATE	Absence Begin Date 06
24	ABS_BEGIN_DT_07	Date(10)	DATE	Absence Begin Date 07
25	ABS_BEGIN_DT_08	Date(10)	DATE	Absence Begin Date 08
26	ABS_BEGIN_DT_09	Date(10)	DATE	Absence Begin Date 09
27	ABS_BEGIN_DT_10	Date(10)	DATE	Absence Begin Date 10
28	ABS_BEGIN_DT_11	Date(10)	DATE	Absence Begin Date 11
29	ABS_BEGIN_DT_12	Date(10)	DATE	Absence Begin Date 12