GP_NRP_ANL_AD

(SQL Table)
Index Back

Absence analytics record

Absence analytics record

# 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
5 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
6 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
7 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID
8 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
9 PIN_TAKE_NUM Number(8,0) INTEGER NOT NULL Absence Take
10 RSLT_VER_NUM Number(4,0) SMALLINT NOT NULL Result Version Number
11 ABS_BGN_DT Date(10) DATE Absence Begin Date
12 ABS_END_DT Date(10) DATE Absence End Date
13 SEG_BGN_DT Date(10) DATE Payee Process Segment's Begin Date
14 SEG_END_DT Date(10) DATE Payee Process Segment's End Date
15 PRD_BGN_DT Date(10) DATE Period Begin Date
16 PRD_END_DT Date(10) DATE Pay Period End Date
17 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
18 DESCR Character(30) VARCHAR2(30) NOT NULL Description
19 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
20 ABS_REASON_DESCR Character(30) VARCHAR2(30) NOT NULL Absence Reason
21 DESCR35_A Character(35) VARCHAR2(35) NOT NULL Job Offer
22 DESCR35_B Character(35) VARCHAR2(35) NOT NULL Notifications
23 DESCR35_C Character(35) VARCHAR2(35) NOT NULL Submitted Applications
24 ACTION_DESCR Character(50) VARCHAR2(50) NOT NULL Action Description
25 GP_HR_ACTION_DESCR Character(30) VARCHAR2(30) NOT NULL GP_HR_ACTION_DESCR