SSR_TRANS_IDSSR_CORRELATION_IDA=OS-HELP for study in Asia
E=Exempt
F=FEE-HELP
H=HECS-HELP
L=OS-HELP Language study
O=OS-HELP
S=SA-HELP
HEP=Higher Education Provider
NA=Not Applicable
TAC=Tertiary Admission Centre
VET=Vocational Education&Training
SSR_HM_LOAN(SQL Table) |
Index Back |
|---|---|
LoansLoan transaction table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SSR_TRANS_ID |
Number(31,0) | DECIMAL(31) NOT NULL | HEIMS Transaction ID |
| 2 | SSR_CORRELATION_ID |
Number(31,0) | DECIMAL(31) NOT NULL | HEIMS Correlation ID |
| 3 | SSR_SEQ_NBR | Number(4,0) | SMALLINT NOT NULL | Sequence Number |
| 4 | SSR_MAP_ID | Number(31,0) | DECIMAL(31) NOT NULL | HEIMS Map ID |
| 5 | SSR_MESSAGE_ID | Number(31,0) | DECIMAL(31) NOT NULL | HEIMS Message ID |
| 6 | SSR_CRSE_ADM_UID | Number(31,0) | DECIMAL(31) NOT NULL | HEIMS Course Admission UID |
| 7 | SSR_STDNT_UID | Number(31,0) | DECIMAL(31) NOT NULL | HEIMS Student UID |
| 8 | SSR_UNIT_ENRL_UID | Number(31,0) | DECIMAL(31) NOT NULL | HEIMS Unit Enrolment UID |
| 9 | SSR_HELP_DEBT_DT | Date(10) | DATE | HELP Debt Incurral Date |
| 10 | SSR_STDNT_STAT_CD | Character(3) | VARCHAR2(3) NOT NULL | Student Status Code |
| 11 | SSR_LOAN_FEE | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Loan Fee |
| 12 | SSR_OSHELP_PAY_AMT | Number(11,2) | DECIMAL(10,2) NOT NULL | OSHELP Payment Amount |
| 13 | SSR_OSHELP_SP_CMDT | Date(10) | DATE | OSHELP Study Period Commencement Date |
| 14 | SSR_OSHELP_PRI_CTY | Character(4) | VARCHAR2(4) NOT NULL | OSHELP Primary Study Country Code |
| 15 | SSR_OSHELP_SEC_CTY | Character(4) | VARCHAR2(4) NOT NULL | OSHELP Secondary Study Country Code |
| 16 | SSR_OSHELP_LANG_CD | Character(4) | VARCHAR2(4) NOT NULL | OSHELP Language Code |
| 17 | SSR_OSHELP_LS_CMDT | Date(10) | DATE | OSHELP Language Study Commencement Date |
| 18 | SSR_AMT_CHARGED | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Amount Charged |
| 19 | SSR_AMT_PAID_UPFRN | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Amount Paid Upfront |
| 20 | SSR_HELP_LOAN_AMT | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | HELP Loan Amount |
| 21 | SSR_PROVIDER_CODE | Character(4) | VARCHAR2(4) NOT NULL | Provider Code |
| 22 | SSR_CRSE_CODE | Character(10) | VARCHAR2(10) NOT NULL | HEIMS Course Code |
| 23 | SSR_UNIT_STDY_CODE | Character(12) | VARCHAR2(12) NOT NULL | HEIMS Unit of Study Code |
| 24 | SSR_UNIT_STDY_CNDT | Date(10) | DATE | Unit of Study Census Date |
| 25 | SSR_HELP_TYPE | Character(7) | VARCHAR2(7) NOT NULL | HELP Type |
| 26 | SSR_ADJ_LOAN_AMT | Number(8,2) | DECIMAL(7,2) NOT NULL | Adjusted Loan Amount |
| 27 | SSR_ADJ_LOAN_FEE | Number(8,2) | DECIMAL(7,2) NOT NULL | Adjusted Loan Fee |
| 28 | SSR_STDNT_ID_CODE | Character(10) | VARCHAR2(10) NOT NULL | Student ID |
| 29 | SSR_STDNT_CHESSN | Character(10) | VARCHAR2(10) NOT NULL | Commonwealth Higher Education Student Support Number (CHESSN) |
| 30 | SSR_LOAN_STATUS | Character(254) | VARCHAR2(254) NOT NULL | Loan Status |
| 31 | IB_RESTMETHOD | Character(10) | VARCHAR2(10) NOT NULL | REST Method |
| 32 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 33 | SSR_HLP_DBT_INC_DT | Date(10) | DATE | HELP Debt Incurral Date Key Field |
| 34 | SSF_AUS_LOAN_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
AUS Loan Type
A=OS-HELP for study in Asia E=Exempt F=FEE-HELP H=HECS-HELP L=OS-HELP Language study O=OS-HELP S=SA-HELP |
| 35 | SSR_PROVIDER_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Provider Type
HEP=Higher Education Provider NA=Not Applicable TAC=Tertiary Admission Centre VET=Vocational Education&Training |
| 36 | SCC_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Created By |
| 37 | SCC_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Created |
| 38 | SCC_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Updated By |
| 39 | SCC_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Last Update Date/Time |