GP_ABS_MSG_VW

(SQL View)
 Index Back

Absence data Incre Sync Msg

This view holds the structure of Absence data Incremental Sync Message

SELECT EMPLID , EMPL_RCD , ' ' , BGN_DT , END_DT , ORIG_BEGIN_DT , MANAGER_APPR_IND , WF_STATUS , PRC_EVT_ACTN_OPTN , BEGIN_DAY_HRS , BEGIN_DAY_HALF_IND , END_DAY_HRS , END_DAY_HALF_IND , ALL_DAYS_IND , START_TIME , END_TIME , START_TIME2 , END_TIME2 , DURATION_ABS , ' ' , ' ' , ' ' , ABS_ENTRY_SRC , ' ' FROM PS_GP_ABS_EVENT ABS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
3 PIN_CODE Character(22) VARCHAR2(22) NOT NULL Unique identifier of a PIN (alternate to PIN number). critical for use in merging packages of elements from one database onto another when PINs may or may not be renumbered as they are moved across. Constructed from PIN_NM + COUNTRY of the element definition (GP_PIN)

Default Value: GP_PIN.PIN_NM

4 BGN_DT Date(10) DATE NOT NULL Begin Date
5 END_DT Date(10) DATE NOT NULL end date
6 ORIG_BEGIN_DT Date(10) DATE original begin date

Default Value: GP_ABS_EVENT.BGN_DT

7 MANAGER_APPR_IND Character(1) VARCHAR2(1) NOT NULL Manager Approved
8 WF_STATUS Character(1) VARCHAR2(1) NOT NULL Workflow Status
A=Approved
C=Cancelled
D=Denied
E=Error. Contact Administrator.
F=Awaiting final approval
I=In Approval Process
M=Administrator is Processing
N=Not Available
P=Rework
S=Submitted
V=Data Saved
9 PRC_EVT_ACTN_OPTN Character(1) VARCHAR2(1) NOT NULL Process Action Event Indicator
N=Normal
V=Void

Default Value: N

10 BEGIN_DAY_HRS Signed Number(6,2) DECIMAL(4,2) NOT NULL Partial Hours
11 BEGIN_DAY_HALF_IND Character(1) VARCHAR2(1) NOT NULL indicates whether first day of an absence event began counts as half a day

Y/N Table Edit

Default Value: N

12 END_DAY_HRS Signed Number(6,2) DECIMAL(4,2) NOT NULL partial hours end
13 END_DAY_HALF_IND Character(1) VARCHAR2(1) NOT NULL half day end indicator

Y/N Table Edit

Default Value: N

14 ALL_DAYS_IND Character(1) VARCHAR2(1) NOT NULL All Days Indicator
N=Apply To Begin Day Only
Y=Apply To All Days

Default Value: N

15 START_TIME Time(15) TIMESTAMP Interview Start Time
16 END_TIME Time(15) TIMESTAMP Interview End Time
17 START_TIME2 Time(15) TIMESTAMP Contains End Time. Primarly created for storing Start Time of Absence Take
18 END_TIME2 Time(15) TIMESTAMP Contains End Time. Primarly created for storing End Time of Absence Take
19 DURATION_ABS Number(7,2) DECIMAL(6,2) NOT NULL Duration field containing 2 decimals to handle absence requirements
20 EXCL_HOLIDAYS Character(1) VARCHAR2(1) NOT NULL This fields indicates if the end date calculation needs to substract holidays
N=No
Y=Yes
21 EXCL_NON_WORK Character(1) VARCHAR2(1) NOT NULL This fields indicates if the end date calculation needs to substract days off
N=No
Y=Yes
22 UNIT_TYPE Character(1) VARCHAR2(1) NOT NULL Unit Type in which the absence balances are displayed
D=Days
H=Hours
23 ABS_ENTRY_SRC Character(1) VARCHAR2(1) NOT NULL Absence Entry Source
1=Administrator Absence Event
2=Time & Labor
3=Third Party
4=Employee Absence Request
5=Manager Absence Request
6=Employee Timesheet
7=Manager Timesheet
A=Employee Extended Absence
B=Manager Extended Absence
C=Administrator Extended Absence
D=Employee Desktop Integration
24 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values