SFA_SLC_TFRADTL

(SQL Table)
Index Back

TFRA Detail

SLC Tuition Fee Remittance Advice Detail Staging Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SFA_SLC_HEI_CD Character(4) VARCHAR2(4) NOT NULL HEI Code
2 SFA_SLC_ACAD_YR Character(4) VARCHAR2(4) NOT NULL SLC Acad Year
3 SFA_FILE_NAME Character(128) VARCHAR2(128) NOT NULL File Name
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_COURSE_PER Character(3) VARCHAR2(3) NOT NULL Course Start Period
AUT=AUT
SPR=SPR
SUM=SUM
WIN=WIN
7 SFA_SLC_LAST_NAME Character(50) VARCHAR2(50) NOT NULL Last Name
8 SFA_SLC_FIRST_NAME Character(50) VARCHAR2(50) NOT NULL First Name
9 SFA_SLC_BIRTHDATE Date(10) DATE Date of Birth
10 SFA_SLC_UCAS_NBR Character(9) VARCHAR2(9) NOT NULL UCAS Number
11 SFA_SLC_COURSE_CD Character(15) VARCHAR2(15) NOT NULL SLC Course Code
12 SFA_SLC_COURSE_NM Character(120) VARCHAR2(120) NOT NULL Course Name
13 SFA_SLC_COURSE_YR Character(1) VARCHAR2(1) NOT NULL Year of Course
14 SFA_SLC_FEE_AMT Signed Number(20,3) DECIMAL(18,3) NOT NULL Fee Amount
15 SFA_SLC_REVISION Character(1) VARCHAR2(1) NOT NULL Revision Indicator
16 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: INSTALLATION.EXCHNG_TO_CURRENCY