SFA_SLC_ACR

(SQL Table)
 Index Back

ACR/TFPR Detail

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

  • Parent record: SFA_SLC_STUDENT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

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

    Default Value: OPR_DEF_TBL_CS.AID_YEAR

    Prompt Table: AID_YEAR_TBL

    4 SFA_SLC_HEI_CD Character(4) VARCHAR2(4) NOT NULL HEI Code

    Prompt Table: SFA_SLC_HEI_VW

    5 SFA_SLC_SEQ Number(3,0) SMALLINT NOT NULL Sequence Number
    6 SFA_SLC_ACAD_YR Character(4) VARCHAR2(4) NOT NULL SLC Acad Year
    7 SFA_SLC_ISSUE_DT Date(10) DATE Issue Date
    8 SFA_SLC_SSN Character(13) VARCHAR2(13) NOT NULL Student Support Nbr
    9 SFA_SLC_COURSE_PER Character(3) VARCHAR2(3) NOT NULL Course Start Period
    AUT=AUT
    SPR=SPR
    SUM=SUM
    WIN=WIN
    10 SFA_SLC_LAST_NAME Character(50) VARCHAR2(50) NOT NULL Last Name
    11 SFA_SLC_FIRST_NAME Character(50) VARCHAR2(50) NOT NULL First Name
    12 SFA_SLC_BIRTHDATE Date(10) DATE Date of Birth
    13 SFA_SLC_UCAS_NBR Character(9) VARCHAR2(9) NOT NULL UCAS Number
    14 SFA_SLC_COURSE_CD Character(15) VARCHAR2(15) NOT NULL SLC Course Code
    15 SFA_SLC_COURSE_NM Character(120) VARCHAR2(120) NOT NULL Course Name
    16 SFA_SLC_COURSE_YR Character(1) VARCHAR2(1) NOT NULL Year of Course
    17 SFA_SLC_COURSE_FEE Number(19,3) DECIMAL(18,3) NOT NULL Course Tuition Fee Amt
    18 SFA_SLC_TUIT_LOAN Signed Number(20,3) DECIMAL(18,3) NOT NULL Tuition Fee Loan Payable
    19 SFA_SLC_TUIT_GRANT Signed Number(20,3) DECIMAL(18,3) NOT NULL Tuition Fee Grant Payable
    20 SFA_SLC_TUIT_STDNT Signed Number(20,3) DECIMAL(18,3) NOT NULL Tuition Fee Student Payable
    21 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
    22 SFA_SLC_FSN_STATDT Date(10) DATE Student Status Date
    23 SFA_SLC_NEW_RECORD Character(3) VARCHAR2(3) NOT NULL New Record
    24 SFA_SLC_REVISION Character(1) VARCHAR2(1) NOT NULL Revision Indicator
    25 SFA_SLC_BURSARY Character(1) VARCHAR2(1) NOT NULL Bursary Student Flag

    Y/N Table Edit

    26 SFA_SLC_VALID_NINO Character(1) VARCHAR2(1) NOT NULL Valid NINO Flag

    Y/N Table Edit

    27 SFA_SLC_DIST_LEARN Character(1) VARCHAR2(1) NOT NULL Disabled Distance Learner

    Y/N Table Edit

    28 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
    29 SFA_SLC_PROC_STAT Character(1) VARCHAR2(1) NOT NULL Processing Status
    K=Skip
    P=Processed
    S=Suspended
    U=Unprocessed

    Default Value: U

    30 SFA_SLC_PROC_DTTM DateTime(26) TIMESTAMP Processed Date/Time
    31 SFA_SLC_TFPR_IND Character(1) VARCHAR2(1) NOT NULL TFPR Indicator

    Y/N Table Edit

    32 SFA_SLC_EQ_ATTSTAT Character(1) VARCHAR2(1) NOT NULL Calculated Attendance
    A=In Attendance
    N=Not in Attendance
    S=Studies Suspended
    33 SFA_SLC_EQ_CRSE_CD Character(6) VARCHAR2(6) NOT NULL Calculated Course Code
    34 SFA_SLC_EQ_CRSE_YR Character(1) VARCHAR2(1) NOT NULL Calculated Course Year
    35 SFA_SLC_EQ_CRSEFEE Number(19,3) DECIMAL(18,3) NOT NULL Calculated Course Fee
    36 SFA_SLC_EQ_TUITLN Signed Number(20,3) DECIMAL(18,3) NOT NULL Calculated Tuit Fee Loan
    37 SFA_SLC_EQ_TUITGNT Signed Number(20,3) DECIMAL(18,3) NOT NULL Calculated Tuit Fee Grant
    38 SFA_SLC_EQ_TUITSTD Signed Number(20,3) DECIMAL(18,3) NOT NULL Calculated Tuit Fee Student
    39 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: INSTALLATION.EXCHNG_TO_CURRENCY

    40 SFA_SLC_TUIT_LN_CD Character(1) VARCHAR2(1) NOT NULL Tuition Fee Loan Payable
    -=Ineligible
    X=Temporary Course Code
    41 SFA_SLC_REC_SEQ Number(6,0) INTEGER NOT NULL Record Sequence
    42 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

    Default Value: ACR

    43 SFA_SLC_CUST_REFNB Character(30) VARCHAR2(30) NOT NULL Customer Reference
    44 SFA_SLC_BANK_DTL Character(1) VARCHAR2(1) NOT NULL Bank Details Held

    Y/N Table Edit

    45 SFA_SLC_ATTEND_STA Character(40) VARCHAR2(40) NOT NULL Attendance Status 1
    46 SFA_SLC_ATTEND_CD Character(1) VARCHAR2(1) NOT NULL Attendance Code 1
    47 SFA_SLC_AWD_AUTH Character(100) VARCHAR2(100) NOT NULL Award Authority
    48 SFA_SLC_SPN_BURCON Character(1) VARCHAR2(1) NOT NULL Sponsor Bursary Consent

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

    52 SFA_SLC_COHORT_YR Number(4,0) SMALLINT NOT NULL Cohort Year
    53 SFA_SLC_PRD_CODE Character(10) VARCHAR2(10) NOT NULL f
    54 SFA_SLC_CALC_FTE Number(5,1) DECIMAL(4,1) NOT NULL Calculated FTE
    55 SFA_SLC_OVR_FTE Number(5,1) DECIMAL(4,1) NOT NULL Override FTE
    56 SFA_SLC_ZERO_FTE Character(1) VARCHAR2(1) NOT NULL Report Zero

    Y/N Table Edit

    Default Value: N

    57 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
    58 SFA_SLC_LIAB_PRD Character(1) VARCHAR2(1) NOT NULL Liability Period
    1=1
    2=2
    3=3

    Default Value: 1

    59 SFA_SLC_ATTEND_ST2 Character(40) VARCHAR2(40) NOT NULL Attendance Status 2
    60 SFA_SLC_ATTEND_ST3 Character(40) VARCHAR2(40) NOT NULL Attendance Status 3
    61 SFA_SLC_ATTEND_CD2 Character(1) VARCHAR2(1) NOT NULL Attendance Code 2
    62 SFA_SLC_ATTEND_CD3 Character(1) VARCHAR2(1) NOT NULL Attendance Code 3
    63 SFA_SLC_REG_CONF Character(1) VARCHAR2(1) NOT NULL Registration Confirmed

    Y/N Table Edit

    64 SFA_SLC_REG_STATUS Character(40) VARCHAR2(40) NOT NULL Registration Status
    65 SFA_SLC_STUDY_MODE Character(2) VARCHAR2(2) NOT NULL Mode Of Study
    66 SFA_SLC_CURYR_STDT Character(6) VARCHAR2(6) NOT NULL Current Year Start Date
    67 SFA_SLC_ACLOAD_OVR Character(1) VARCHAR2(1) NOT NULL Academic Load Override
    F=Full Time
    P=Part Time
    68 SFA_SLC_APP_STATUS Character(30) VARCHAR2(30) NOT NULL Application Status
    69 SFA_SLC_UCAS_CRSCD Character(6) VARCHAR2(6) NOT NULL UCAS Course Code
    70 SFA_SLC_LEVEL_FUND Character(2) VARCHAR2(2) NOT NULL Level of Funding
    71 SFA_SLC_CREDIT_VAL Number(4,0) SMALLINT NOT NULL Credit Value