SFA_SLC_SSAR(SQL Table) |
Index Back |
---|---|
SLC Student SSAR DataSLC Student Support Attendance Request Data Table |
# | 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 |
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_FILE_SEQ | Number(5,0) | INTEGER NOT NULL | Sequence Number |
8 | SFA_SLC_ISSUE_DT | Date(10) | DATE | Issue Date |
9 | SFA_SLC_TITLE | Character(10) | VARCHAR2(10) NOT NULL | Title |
10 | SFA_SLC_FIRST_NAME | Character(50) | VARCHAR2(50) NOT NULL | First Name |
11 | SFA_SLC_MIDDLE | Character(50) | VARCHAR2(50) NOT NULL | Middle Name |
12 | SFA_SLC_LAST_NAME | Character(50) | VARCHAR2(50) NOT NULL | Last Name |
13 | SFA_SLC_SEX | Character(1) | VARCHAR2(1) NOT NULL |
Sex
F=Female M=Male |
14 | SFA_SLC_BIRTHDATE | Date(10) | DATE | Date of Birth |
15 | SFA_SLC_UCAS_NBR | Character(9) | VARCHAR2(9) NOT NULL | UCAS Number |
16 | SFA_SLC_UCAS_CRSCD | Character(6) | VARCHAR2(6) NOT NULL | UCAS Course Code |
17 | SFA_SLC_COURSE_CD | Character(15) | VARCHAR2(15) NOT NULL | SLC Course Code |
18 | SFA_SLC_COURSE_NM | Character(120) | VARCHAR2(120) NOT NULL | Course Name |
19 | SFA_SLC_COURSE_YR | Character(1) | VARCHAR2(1) NOT NULL | Year of Course |
20 | SFA_SLC_COURSE_DT | Date(10) | DATE | Course Start Date |
21 | SFA_SLC_POST_CD | Character(8) | VARCHAR2(8) NOT NULL | Post Code |
22 | SFA_SLC_COURSE_FEE | Number(19,3) | DECIMAL(18,3) NOT NULL | Course Tuition Fee Amt |
23 | SFA_SLC_SSN | Character(13) | VARCHAR2(13) NOT NULL | Student Support Nbr |
24 | SFA_SLC_TUIT_LOAN | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Tuition Fee Loan Payable |
25 | SFA_SLC_TUIT_GRANT | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Tuition Fee Grant Payable |
26 | SFA_SLC_TUIT_STDNT | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Tuition Fee Student Payable |
27 | SFA_SLC_LOAN_APPLY | Character(1) | VARCHAR2(1) NOT NULL |
Loan Applied For
F=Full Entitlement N=No Loan applied for P=Part Entitlement |
28 | SFA_SLC_GRANT_PAYB | Character(1) | VARCHAR2(1) NOT NULL |
Grant Payable
Y/N Table Edit |
29 | 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 |
30 | SFA_SLC_BANK_DTL | Character(1) | VARCHAR2(1) NOT NULL |
Bank Details Held
Y/N Table Edit |
31 | SFA_SLC_COA_IND | Character(1) | VARCHAR2(1) NOT NULL |
Attendance Confirmed
Y/N Table Edit |
32 | SFA_SLC_VALID_NINO | Character(1) | VARCHAR2(1) NOT NULL |
Valid NINO Flag
Y/N Table Edit |
33 | SFA_SLC_DIST_LEARN | Character(1) | VARCHAR2(1) NOT NULL |
Disabled Distance Learner
Y/N Table Edit |
34 | SFA_SLC_CREDIT_VAL | Number(4,0) | SMALLINT NOT NULL | Credit Value |
35 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: INSTALLATION.EXCHNG_TO_CURRENCY |
36 | SFA_SLC_ADDRESS | Long Character(340) | VARCHAR2(340) | Address |