ABS_ORIG_VW

(SQL View)
Index Back

Original Absence Hist View

The Original Absence History view is used to select a previous absence for an employee in case of recurrence.

SELECT EMPLID ,EMPL_RCD ,BEGIN_DT ,ABSENCE_TYPE ,RETURN_DT ,ABSENCE_CODE ,ABS_RECURRENCE ,ORIG_BEGIN_DT_BEL ,'N' FROM PS_ABSENCE_HIST WHERE ABS_ENTRY_PANEL = 'GEN'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 ORIG_EMPL_RCD_BEL Number(3,0) SMALLINT NOT NULL Employment Record Nbr
3 ORIG_BEGIN_DT_BEL Date(10) DATE Original Start Date
4 ORIG_ABS_TYPE_BEL Character(3) VARCHAR2(3) NOT NULL Original Absence Type
5 RETURN_DT Date(10) DATE Return Date
6 ABSENCE_CODE Character(3) VARCHAR2(3) NOT NULL Absence Code
7 ABS_RECURRENCE Character(1) VARCHAR2(1) NOT NULL Absence Recurrence

Y/N Table Edit

Default Value: N

8 BEGIN_DT Date(10) DATE Begin Date
9 SELECT_ABSENCE Character(1) VARCHAR2(1) NOT NULL Select Absence is used within Absence History to select a previous absence in case of recurrence.

Y/N Table Edit

Default Value: N