SFA_SLC_ACRXBND

(SQL View)
 Index Back

SLC ACRX PopSelect Bind

SLC Attendance Confirmation Report Export Population Select Bind Record

SELECT A.emplid ,A.Institution ,A.AID_YEAR , A.SFA_SLC_HEI_CD ,A.SFA_SLC_ISSUE_DT ,A.SFA_SLC_LIAB_PRD ,A.SFA_SLC_SSN , A.SFA_SLC_FILE_TYPE1 ,A.SFA_SLC_ACAD_LOAD ,A.SFA_SLC_CALC_FTE ,A.SFA_SLC_OVR_FTE ,A.SFA_SLC_ZERO_FTE FROM %Table(SFA_SLC_ACR) A WHERE A.SFA_SLC_SEQ = ( SELECT MAX(SFA_SLC_SEQ) FROM %Table(SFA_SLC_ACR) B , %Table(SFA_SLC_ACR_HDR) HDR WHERE A.EMPLID = B.EMPLID AND A.Institution = B.Institution AND A.SFA_SLC_HEI_CD = B.SFA_SLC_HEI_CD AND A.SFA_SLC_ACAD_YR = B.SFA_SLC_ACAD_YR AND HDR.SFA_SLC_HEI_CD = B.SFA_SLC_HEI_CD AND HDR.SFA_SLC_ACAD_YR = B.SFA_SLC_ACAD_YR AND HDR.SFA_SLC_ISSUE_DT = B.SFA_SLC_ISSUE_DT AND HDR.SFA_SLC_LIAB_PRD = B.SFA_SLC_LIAB_PRD AND HDR.SFA_SLC_PROC_STAT = 'U' )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
3 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year
4 SFA_SLC_HEI_CD Character(4) VARCHAR2(4) NOT NULL HEI Code
5 SFA_SLC_ISSUE_DT Date(10) DATE Issue Date
6 SFA_SLC_LIAB_PRD Character(1) VARCHAR2(1) NOT NULL Liability Period
1=1
2=2
3=3
7 SFA_SLC_SSN Character(13) VARCHAR2(13) NOT NULL Student Support Nbr
8 SFA_SLC_FILE_TYPE1 Character(3) VARCHAR2(3) NOT NULL File Type
ACR=Attendance Confirmation Reqst
EXT=Extended SISF
SCA=Short Course Attendance
SIS=Student Information Service
9 SFA_SLC_ACAD_LOAD Character(1) VARCHAR2(1) NOT NULL Academic Load
B=Both Full Time and Part Time
F=Full Time
N=None
P=Part Time
10 SFA_SLC_CALC_FTE Number(5,1) DECIMAL(4,1) NOT NULL Calculated FTE
11 SFA_SLC_OVR_FTE Number(5,1) DECIMAL(4,1) NOT NULL Override FTE
12 SFA_SLC_ZERO_FTE Character(1) VARCHAR2(1) NOT NULL Report Zero