ABSENCE_CAL_VW

(SQL View)
Index Back

Absence Calendar Employee View

Absence Calendar Employee View

select A.CALYEAR ,A.MONTHCD ,B.EMPLID ,B.EMPL_RCD ,B.BEGIN_DT ,B.ABSENCE_TYPE ,B.RETURN_DT from PS_ABSENCE_CAL A ,PS_ABSENCE_HIST B where B.BEGIN_DT <= A.ABS_MONTH_END_DT and (B.RETURN_DT >= A.ABS_MONTH_START_DT or B.RETURN_DT is null)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CALYEAR Number(4,0) SMALLINT NOT NULL Year
2 MONTHCD Character(2) VARCHAR2(2) NOT NULL Month
01=01 - January
02=02 - February
03=03 - March
04=04 - April
05=05 - May
06=06 - June
07=07 - July
08=08 - August
09=09 - September
10=10 - October
11=11 - November
12=12 - December
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
5 BEGIN_DT Date(10) DATE Begin Date
6 ABSENCE_TYPE Character(3) VARCHAR2(3) NOT NULL Absence Type
7 RETURN_DT Date(10) DATE Return Date