SFA_SLC_ACRDTV2

(SQL View)
Index Back

ACR Issue Date View 2

Attendance Confirmation Report Issue Date Prompt View 2

SELECT DISTINCT A.INSTITUTION ,A.AID_YEAR ,A.SFA_SLC_HEI_CD , B.SFA_SLC_LIAB_PRD ,B.SFA_SLC_ISSUE_DT ,B.SFA_SLC_ACAD_YR ,B.SFA_SLC_HEI_NAME ,B.SFA_SLC_REC_COUNT FROM PS_SFA_SLC_SETUP A , PS_SFA_SLC_ACR_HDR B WHERE A.SFA_SLC_HEI_CD = B.SFA_SLC_HEI_CD AND A.SFA_SLC_ACAD_YR = B.SFA_SLC_ACAD_YR AND B.SFA_SLC_PROC_STAT <> 'P' AND B.SFA_SLC_FILE_TYPE1 = 'ACR'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Prompt Table: INSTITUTION_TBL

2 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

Prompt Table: AID_YEAR_TBL

3 SFA_SLC_HEI_CD Character(4) VARCHAR2(4) NOT NULL HEI Code
4 SFA_SLC_LIAB_PRD Character(1) VARCHAR2(1) NOT NULL Liability Period
1=1
2=2
3=3
5 SFA_SLC_ISSUE_DT Date(10) DATE NOT NULL Issue Date
6 SFA_SLC_ACAD_YR Character(4) VARCHAR2(4) NOT NULL SLC Acad Year
7 SFA_SLC_HEI_NAME Character(50) VARCHAR2(50) NOT NULL HEI Name
8 SFA_SLC_REC_COUNT Number(6,0) INTEGER NOT NULL Record Count