GP_NRP_RSAPG_VW

(SQL View)
 Index Back

Absence analytics History

Absence analytics record HISTORY.

SELECT %subrec(PSARCHIVE_SBR, A) , A.EMPLID , A.CAL_RUN_ID , A.EMPL_RCD , A.GP_PAYGROUP , A.CAL_ID , A.ORIG_CAL_RUN_ID , A.RSLT_SEG_NUM , A.PIN_TAKE_NUM + 50000000 , A.RSLT_VER_NUM , A.ABS_BGN_DT , A.ABS_END_DT , A.SEG_BGN_DT , A.SEG_END_DT , A.PRD_BGN_DT , A.PRD_END_DT , A.ELIG_IND , A.MIN_IND , A.LINKED_IND , A.ORIG_BEGIN_DT , A.ABS_TYPE_OPTN , A.DESCR , A.PIN_NM , A.DESCR1 , A.ABSENCE_REASON , A.ABS_REASON_DESCR , A.DAY_STATUS , A.END_ENTL_BAL , A.PIN_MAP_TO_NUM + 50000000 , A.DESCR35_A , A.PIN_SOURCE_NUM + 50000000 , A.DESCR35_B , A.PIN_NEG_ABS_NUM + 50000000 , A.DESCR35_C , A.GP_NEG_BAL_OPTN , A.GP_PG_NEG_BAL_IDT , A.ABS_EVT_FCST_VAL , A.RETRO_IND , A.ACTION , A.ACTION_DESCR , A.PAY_ENTITY , A.PAYGROUP , A.WORKGROUP , A.GP_ATTRIBUTE_NAME , A.GP_HR_ACTION_DESCR , A.COUNTRY , A.STRM_NUM , A.GROUP_LIST_ID , A.ABS_DATA_SRC , A.GP_ABS_EVT_STATUS , A.GP_PG_ABS_EVT_STAT , A.ERNCD , A.CURRENCY_CD , A.SCHED_HRS_TOTAL , A.DAY_COUNT , A.DAY_COUNT_PAID , A.DAY_COUNT_UNPAID , A.COMPUTED_COST , A.ACTUAL_COST , A.TOTAL_RPTD_UNIT , A.GP_AGGR_COUNT , A.GP_PG_ABS_CNT , A.LASTUPDDTTM FROM PS_GP_PG_ANLYT_HST A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
5 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
6 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
7 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
8 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID
9 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
10 PIN_TAKE_NUM Number(8,0) INTEGER NOT NULL Absence Take
11 RSLT_VER_NUM Number(4,0) SMALLINT NOT NULL Result Version Number
12 ABS_BGN_DT Date(10) DATE Absence Begin Date
13 ABS_END_DT Date(10) DATE Absence End Date
14 SEG_BGN_DT Date(10) DATE Payee Process Segment's Begin Date
15 SEG_END_DT Date(10) DATE Payee Process Segment's End Date
16 PRD_BGN_DT Date(10) DATE Period Begin Date
17 PRD_END_DT Date(10) DATE Pay Period End Date
18 ELIG_IND Character(1) VARCHAR2(1) NOT NULL Eligibility Indicator
19 MIN_IND Character(1) VARCHAR2(1) NOT NULL Minimum Period Indicator
20 LINKED_IND Character(1) VARCHAR2(1) NOT NULL Linked Indicator
21 ORIG_BEGIN_DT Date(10) DATE original begin date
22 ABS_TYPE_OPTN Character(3) VARCHAR2(3) NOT NULL Absence Type
23 DESCR Character(30) VARCHAR2(30) NOT NULL Description
24 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field
25 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
26 ABSENCE_REASON Character(3) VARCHAR2(3) NOT NULL absence reason
27 ABS_REASON_DESCR Character(30) VARCHAR2(30) NOT NULL Absence Reason
28 DAY_STATUS Character(1) VARCHAR2(1) NOT NULL Processing status on an absence date. Processed (P) or Unprocessed (U)
P=Processed
U=Unprocessed
29 END_ENTL_BAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Entitlement Balance
30 PIN_MAP_TO_NUM Number(8,0) INTEGER NOT NULL Element number field
31 DESCR35_A Character(35) VARCHAR2(35) NOT NULL Job Offer
32 PIN_SOURCE_NUM Number(8,0) INTEGER NOT NULL Element number field
33 DESCR35_B Character(35) VARCHAR2(35) NOT NULL Notifications
34 PIN_NEG_ABS_NUM Number(8,0) INTEGER NOT NULL Element number field
35 DESCR35_C Character(35) VARCHAR2(35) NOT NULL Submitted Applications
36 GP_NEG_BAL_OPTN Character(45) VARCHAR2(45) NOT NULL Negative Balance Option
37 GP_PG_NEG_BAL_IDT Character(1) VARCHAR2(1) NOT NULL GP_PG_NEG_BAL_IDT
N=Paid Through Negative Balance
T=Generated From Another Take
38 ABS_EVT_FCST_VAL Character(30) VARCHAR2(30) NOT NULL This field is used on the GP_ABS_EVENT record to record the value of the resolved related forecast element.
39 RETRO_IND Character(1) VARCHAR2(1) NOT NULL Retro Indicator
40 ACTION Character(3) VARCHAR2(3) NOT NULL Action
41 ACTION_DESCR Character(50) VARCHAR2(50) NOT NULL Action Description
42 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
43 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
44 WORKGROUP Character(10) VARCHAR2(10) NOT NULL Workgroup
45 GP_ATTRIBUTE_NAME Character(4) VARCHAR2(4) NOT NULL ATTRIBUTE_NAME
NEWH=New Hire
OLVA=On Leave Of Absence
RFL=Return From Leave
TERM=Terminated
46 GP_HR_ACTION_DESCR Character(30) VARCHAR2(30) NOT NULL GP_HR_ACTION_DESCR
47 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
48 STRM_NUM Number(4,0) SMALLINT NOT NULL Stream Number
49 GROUP_LIST_ID Character(10) VARCHAR2(10) NOT NULL Group List
50 ABS_DATA_SRC Character(1) VARCHAR2(1) NOT NULL Absence Data Source: Event or Take Processing
1=Event Processing
2=Take Processing
51 GP_ABS_EVT_STATUS Character(22) VARCHAR2(22) NOT NULL GP_ABS_EVT_STATUS
52 GP_PG_ABS_EVT_STAT Character(1) VARCHAR2(1) NOT NULL GP_PG_ABS_EVT_STAT
F=Fully Unpaid
P=Partially Paid
53 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code
54 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
55 SCHED_HRS_TOTAL Number(7,2) DECIMAL(6,2) NOT NULL Total Scheduled Hours
56 DAY_COUNT Signed Number(20,6) DECIMAL(18,6) NOT NULL Day Count
57 DAY_COUNT_PAID Signed Number(20,6) DECIMAL(18,6) NOT NULL Day Count Paid
58 DAY_COUNT_UNPAID Signed Number(20,6) DECIMAL(18,6) NOT NULL Day Count Unpaid
59 COMPUTED_COST Number(19,3) DECIMAL(18,3) NOT NULL Variable Cost
60 ACTUAL_COST Number(19,3) DECIMAL(18,3) NOT NULL Actual Cost
61 TOTAL_RPTD_UNIT Signed Number(20,6) DECIMAL(18,6) NOT NULL Total Reported Units for Approval.
62 GP_AGGR_COUNT Number(9,1) DECIMAL(8,1) NOT NULL field used to present processing statistics
63 GP_PG_ABS_CNT Number(7,0) INTEGER NOT NULL field used to present processing statistics
64 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.