SFA_SLC_ACR_DTL

(SQL Table)
 Index Back

ACR/TFPR Detail

SLC Attendance Confirmation Report/Tuition Fee Position Report Detail Staging Table

  • Parent record: SFA_SLC_ACR_HDR

    • # 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_SLC_ISSUE_DT Date(10) DATE NOT NULL Issue Date
    4 SFA_SLC_SSN Character(13) VARCHAR2(13) NOT NULL Student Support Nbr
    5 SFA_SLC_LIAB_PRD Character(1) VARCHAR2(1) NOT NULL Liability Period
    1=1
    2=2
    3=3

    Default Value: 1

    6 SFA_SLC_REC_SEQ Number(6,0) INTEGER NOT NULL Record Sequence
    7 SFA_SLC_COURSE_PER Character(3) VARCHAR2(3) NOT NULL Course Start Period
    AUT=AUT
    SPR=SPR
    SUM=SUM
    WIN=WIN
    8 SFA_SLC_LAST_NAME Character(50) VARCHAR2(50) NOT NULL Last Name
    9 SFA_SLC_FIRST_NAME Character(50) VARCHAR2(50) NOT NULL First Name
    10 SFA_SLC_BIRTHDATE Date(10) DATE Date of Birth
    11 SFA_SLC_UCAS_NBR Character(9) VARCHAR2(9) NOT NULL UCAS Number
    12 SFA_SLC_COURSE_CD Character(15) VARCHAR2(15) NOT NULL SLC Course Code
    13 SFA_SLC_COURSE_NM Character(120) VARCHAR2(120) NOT NULL Course Name
    14 SFA_SLC_COURSE_YR Character(1) VARCHAR2(1) NOT NULL Year of Course
    15 SFA_SLC_COURSE_FEE Number(19,3) DECIMAL(18,3) NOT NULL Course Tuition Fee Amt
    16 SFA_SLC_TUIT_LOAN Signed Number(20,3) DECIMAL(18,3) NOT NULL Tuition Fee Loan Payable
    17 SFA_SLC_TUIT_GRANT Signed Number(20,3) DECIMAL(18,3) NOT NULL Tuition Fee Grant Payable
    18 SFA_SLC_TUIT_STDNT Signed Number(20,3) DECIMAL(18,3) NOT NULL Tuition Fee Student Payable
    19 SFA_SLC_FSN_STAT Character(1) VARCHAR2(1) NOT NULL Student Status
    B=Living Costs and Fees
    D=Deceased
    F=Final
    K=Resumption (3rd term)
    L=Living Costs
    N=Resumption (2nd term)
    P=Provisional
    S=Suspend
    T=Transfer Fees to prev college
    V=Transfer Fees to new college
    W=Withdrawn (Final)
    Y=Withdrawn (Provisional)
    Z=Study in second term only
    20 SFA_SLC_FSN_STATDT Date(10) DATE Student Status Date
    21 SFA_SLC_NEW_RECORD Character(3) VARCHAR2(3) NOT NULL New Record
    22 SFA_SLC_REVISION Character(1) VARCHAR2(1) NOT NULL Revision Indicator
    23 SFA_SLC_BURSARY Character(1) VARCHAR2(1) NOT NULL Bursary Student Flag
    24 SFA_SLC_VALID_NINO Character(1) VARCHAR2(1) NOT NULL Valid NINO Flag
    25 SFA_SLC_DIST_LEARN Character(1) VARCHAR2(1) NOT NULL Disabled Distance Learner
    26 SFA_SLC_ATTEND_IND Character(1) VARCHAR2(1) NOT NULL Attendance Indicator
    A=Data Matches
    C=Course/Year Mismatch
    D=Never Attended
    F=Course Fee Mismatch
    L=Liability Mismatch(reparation)
    N=Liability Mismatch
    S=Studies Suspended
    X=Not in Attendance
    27 SFA_SLC_PROC_STAT Character(1) VARCHAR2(1) NOT NULL Processing Status
    K=Skip
    P=Processed
    S=Suspended
    U=Unprocessed

    Default Value: U

    28 SFA_SLC_PROC_DTTM DateTime(26) TIMESTAMP Processed Date/Time
    29 SFA_SLC_SUSPND_RSN Character(1) VARCHAR2(1) NOT NULL Suspense Reason
    1=Student not found
    2=Multiple student matches found
    3=Match Option set to Suspend
    4=SSN linked to another ID
    5=ID linked to another SSN
    30 MAX_MATCH_LEVEL Number(3,0) SMALLINT NOT NULL Max Search Match Level
    31 MATCH_NBR Number(6,0) INTEGER NOT NULL Number of Matches
    32 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    33 ID_OVERRIDE Character(1) VARCHAR2(1) NOT NULL ID Override
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    34 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: INSTALLATION.EXCHNG_TO_CURRENCY

    35 SFA_SLC_TUIT_LN_CD Character(1) VARCHAR2(1) NOT NULL Tuition Fee Loan Payable
    -=Ineligible
    X=Temporary Course Code
    36 SFA_SLC_CUST_REFNB Character(30) VARCHAR2(30) NOT NULL Customer Reference
    37 SFA_SLC_BANK_DTL Character(1) VARCHAR2(1) NOT NULL Bank Details Held

    Y/N Table Edit

    38 SFA_SLC_ATTEND_STA Character(40) VARCHAR2(40) NOT NULL Attendance Status 1
    39 SFA_SLC_ATTEND_CD Character(1) VARCHAR2(1) NOT NULL Attendance Code 1
    40 SFA_SLC_AWD_AUTH Character(100) VARCHAR2(100) NOT NULL Award Authority
    41 SFA_SLC_SPN_BURCON Character(1) VARCHAR2(1) NOT NULL Sponsor Bursary Consent

    Y/N Table Edit

    42 SFA_SLC_STU_BURCON Character(1) VARCHAR2(1) NOT NULL Student Bursary Consent

    Y/N Table Edit

    43 SFA_SLC_CHDCAREIND Character(1) VARCHAR2(1) NOT NULL Child Care Grant Indicator

    Y/N Table Edit

    44 SFA_SLC_NHS_BURIND Character(1) VARCHAR2(1) NOT NULL NHS Bursary Indicator

    Y/N Table Edit

    45 SFA_SLC_COHORT_YR Number(4,0) SMALLINT NOT NULL Cohort Year
    46 SFA_SLC_ATTEND_ST2 Character(40) VARCHAR2(40) NOT NULL Attendance Status 2
    47 SFA_SLC_ATTEND_ST3 Character(40) VARCHAR2(40) NOT NULL Attendance Status 3
    48 SFA_SLC_ATTEND_CD2 Character(1) VARCHAR2(1) NOT NULL Attendance Code 2
    49 SFA_SLC_ATTEND_CD3 Character(1) VARCHAR2(1) NOT NULL Attendance Code 3
    50 SFA_SLC_REG_CONF Character(1) VARCHAR2(1) NOT NULL Registration Confirmed

    Y/N Table Edit

    51 SFA_SLC_REG_STATUS Character(40) VARCHAR2(40) NOT NULL Registration Status
    52 SFA_SLC_STUDY_MODE Character(2) VARCHAR2(2) NOT NULL Mode Of Study
    53 SFA_SLC_CURYR_STDT Character(6) VARCHAR2(6) NOT NULL Current Year Start Date
    54 SFA_SLC_EXP_FLAG Character(1) VARCHAR2(1) NOT NULL ACR Exported Flag
    55 SFA_SLC_APP_STATUS Character(30) VARCHAR2(30) NOT NULL Application Status
    56 SFA_SLC_UCAS_CRSCD Character(6) VARCHAR2(6) NOT NULL UCAS Course Code
    57 SFA_SLC_LEVEL_FUND Character(2) VARCHAR2(2) NOT NULL Level of Funding
    58 SFA_SLC_CREDIT_VAL Number(4,0) SMALLINT NOT NULL Credit Value