ABS_ORIG_VW(SQL View) |
Index Back |
---|---|
Original Absence Hist ViewThe 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 |