HGA_MANO_NRP_VW

(SQL View)
 Index Back

Manage Abs Options

Table to store Manage Absence Options

SELECT OPERATOR , COMPONENT_ID , HGA_SEARCH_OPTION , PIN_TK_NUM + 50000000 , APPROVER_OPRID , EMPLID , EMPL_RCD , DEPTID , GP_PAYGROUP , HR_STATUS , EMPLID_START , EMPLID_END , LASTNAME_FROM , LASTNAME_TO , DATE_FROM , DATE_TO , ABS_BEGIN_DT_01 , ABS_BEGIN_DT_02 , ABS_BEGIN_DT_03 , ABS_BEGIN_DT_04 , ABS_BEGIN_DT_05 , ABS_BEGIN_DT_06 , ABS_BEGIN_DT_07 , ABS_BEGIN_DT_08 , ABS_BEGIN_DT_09 , ABS_BEGIN_DT_10 , ABS_BEGIN_DT_11 , ABS_BEGIN_DT_12 FROM PS_HGA_MAN_OPTN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPERATOR Character(30) VARCHAR2(30) NOT NULL User ID
2 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.
3 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
4 PIN_TK_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN

5 APPROVER_OPRID Character(30) VARCHAR2(30) NOT NULL Approver Oper ID
6 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
7 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
8 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPT_TBL

9 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
10 HR_STATUS Character(1) VARCHAR2(1) NOT NULL HR Status
A=Active
I=Inactive
11 EMPLID_START Character(11) VARCHAR2(11) NOT NULL Payee ID1
12 EMPLID_END Character(11) VARCHAR2(11) NOT NULL Payee ID1
13 LASTNAME_FROM Character(15) VARCHAR2(15) NOT NULL Last Name FROM
14 LASTNAME_TO Character(15) VARCHAR2(15) NOT NULL Last Name TO
15 DATE_FROM Date(10) DATE Date From
16 DATE_TO Date(10) DATE Previous Period Date To
17 ABS_BEGIN_DT_01 Date(10) DATE Absence Begin Date 01
18 ABS_BEGIN_DT_02 Date(10) DATE Absence Begin Date 02
19 ABS_BEGIN_DT_03 Date(10) DATE Absence Begin Date 03
20 ABS_BEGIN_DT_04 Date(10) DATE Absence Begin Date 04
21 ABS_BEGIN_DT_05 Date(10) DATE Absence Begin Date 05
22 ABS_BEGIN_DT_06 Date(10) DATE Absence Begin Date 06
23 ABS_BEGIN_DT_07 Date(10) DATE Absence Begin Date 07
24 ABS_BEGIN_DT_08 Date(10) DATE Absence Begin Date 08
25 ABS_BEGIN_DT_09 Date(10) DATE Absence Begin Date 09
26 ABS_BEGIN_DT_10 Date(10) DATE Absence Begin Date 10
27 ABS_BEGIN_DT_11 Date(10) DATE Absence Begin Date 11
28 ABS_BEGIN_DT_12 Date(10) DATE Absence Begin Date 12