Temperory Record to hold the contents of the final SLC Log Report.

SFA_SLC_LOG

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 SFA_SLC_ACAD_PROG Character(5) VARCHAR2(5) NOT NULL To store the Acad Prog value during SLC FTE Calculation.
3 NAME Character(50) VARCHAR2(50) NOT NULL Name
4 SFA_SLC_ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL To store the Acad Plan value during SLC FTE Calculation.
5 SFA_SLC_ACAD_SPLAN Character(10) VARCHAR2(10) NOT NULL To store the Acad Sub Plan value during SLC FTE Calculation.
6 SSR_HE_CALC_FTE Number(5,1) DECIMAL(4,1) NOT NULL Calculated FTE