SFA_SLC_TFRASRC

(SQL View)
 Index Back

SLC TFRA Staging Search Record

SLC TFRA Staging Table Search Record

SELECT A.SFA_SLC_HEI_CD ,A.SFA_SLC_ACAD_YR ,A.SFA_FILE_NAME ,B.SFA_SLC_SSN ,B.SFA_SLC_REC_SEQ ,A.SFA_SLC_PAYMNT_DT ,A.SFA_SLC_PAYMNT_TYP ,A.SFA_SLC_SUPP_TYPE ,B.SFA_SLC_LAST_NAME ,B.SFA_SLC_FIRST_NAME ,B.SFA_SLC_BIRTHDATE ,B.SFA_SLC_UCAS_NBR FROM PS_SFA_SLC_TFRAHDR A , PS_SFA_SLC_TFRADTL B WHERE A.SFA_SLC_HEI_CD = B.SFA_SLC_HEI_CD AND A.SFA_SLC_ACAD_YR = B.SFA_SLC_ACAD_YR AND A.SFA_FILE_NAME = B.SFA_FILE_NAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SFA_SLC_HEI_CD Character(4) VARCHAR2(4) NOT NULL HEI Code

Prompt Table: SFA_SLC_HEI_VW

2 SFA_SLC_ACAD_YR Character(4) VARCHAR2(4) NOT NULL SLC Acad Year

Prompt Table: SFA_SLC_ACYR_VW

3 SFA_FILE_NAME Character(128) VARCHAR2(128) NOT NULL File Name

Prompt Table: SFA_SLC_TFRAHDR

4 SFA_SLC_SSN Character(13) VARCHAR2(13) NOT NULL Student Support Nbr
5 SFA_SLC_REC_SEQ Number(6,0) INTEGER NOT NULL Record Sequence
6 SFA_SLC_PAYMNT_DT Date(10) DATE Payment Date
7 SFA_SLC_PAYMNT_TYP Character(1) VARCHAR2(1) NOT NULL Payment Type
G=Tuition Fee Grant
T=Tuition Fee Loan
8 SFA_SLC_SUPP_TYPE Character(2) VARCHAR2(2) NOT NULL Support Type
FT=Full Time
PT=Part Time
9 SFA_SLC_LAST_NAME Character(50) VARCHAR2(50) NOT NULL Last Name
10 SFA_SLC_FIRST_NAME Character(50) VARCHAR2(50) NOT NULL First Name
11 SFA_SLC_BIRTHDATE Date(10) DATE Date of Birth
12 SFA_SLC_UCAS_NBR Character(9) VARCHAR2(9) NOT NULL UCAS Number