GP_ABS_MSG_VW1 (SQL View)	Index Back
Absence data Full Sync Message This view holds the structure of Absence data Full Sync Message

GP_ABS_MSG_VW1

(SQL View)

Absence data Full Sync Message

This view holds the structure of Absence data Full Sync Message

SELECT ABS.EMPLID , ABS.EMPL_RCD , PN.PIN_CODE , BGN_DT , END_DT , ORIG_BEGIN_DT , 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 , UNIT_TYPE , ABS_ENTRY_SRC FROM PS_GP_ABS_EVENT ABS , PS_GP_PIN PN , PS_GP_SS_EE_RCD_VW CNTRY , PS_GP_ABS_SS CNTRYTK , PS_PER_ORG_OWS_VW PEROWS WHERE ABS.EMPLID=CNTRY.EMPLID AND ABS.EMPL_RCD =CNTRY.EMPL_RCD AND ABS.PIN_TAKE_NUM = PN.PIN_NUM AND ABS.MANAGER_APPR_IND = 'Y' AND CNTRY.COUNTRY = CNTRYTK.COUNTRY AND ABS.PIN_TAKE_NUM = CNTRYTK.PIN_TAKE_NUM AND ABS.EMPLID=PEROWS.EMPLID AND ABS.EMPL_RCD =PEROWS.EMPL_RCD

# 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)

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 PRC_EVT_ACTN_OPTN Character(1) VARCHAR2(1) NOT NULL Process Action Event Indicator
N=Normal
V=Void
Default Value: N

8 BEGIN_DAY_HRS Signed Number(6,2) DECIMAL(4,2) NOT NULL Partial Hours

9 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

10 END_DAY_HRS Signed Number(6,2) DECIMAL(4,2) NOT NULL partial hours end

11 END_DAY_HALF_IND Character(1) VARCHAR2(1) NOT NULL half day end indicator
Y/N Table Edit
Default Value: N

12 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

13 START_TIME Time(15) TIMESTAMP Interview Start Time

14 END_TIME Time(15) TIMESTAMP Interview End Time

15 START_TIME2 Time(15) TIMESTAMP Contains End Time. Primarly created for storing Start Time of Absence Take

16 END_TIME2 Time(15) TIMESTAMP Contains End Time. Primarly created for storing End Time of Absence Take

17 DURATION_ABS Number(7,2) DECIMAL(6,2) NOT NULL Duration field containing 2 decimals to handle absence requirements

18 UNIT_TYPE Character(1) VARCHAR2(1) NOT NULL Unit Type in which the absence balances are displayed
D=Days
H=Hours

19 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

#	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)
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	PRC_EVT_ACTN_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Process Action Event Indicator N=Normal V=Void Default Value: N
8	BEGIN_DAY_HRS	Signed Number(6,2)	DECIMAL(4,2) NOT NULL	Partial Hours
9	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
10	END_DAY_HRS	Signed Number(6,2)	DECIMAL(4,2) NOT NULL	partial hours end
11	END_DAY_HALF_IND	Character(1)	VARCHAR2(1) NOT NULL	half day end indicator Y/N Table Edit Default Value: N
12	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
13	START_TIME	Time(15)	TIMESTAMP	Interview Start Time
14	END_TIME	Time(15)	TIMESTAMP	Interview End Time
15	START_TIME2	Time(15)	TIMESTAMP	Contains End Time. Primarly created for storing Start Time of Absence Take
16	END_TIME2	Time(15)	TIMESTAMP	Contains End Time. Primarly created for storing End Time of Absence Take
17	DURATION_ABS	Number(7,2)	DECIMAL(6,2) NOT NULL	Duration field containing 2 decimals to handle absence requirements
18	UNIT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Unit Type in which the absence balances are displayed D=Days H=Hours
19	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