SSR_HM_COURSE

(SQL Table)
Index Back

HEIMS Course

HEIMS Course 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_STDY_UID Number(31,0) DECIMAL(31) NOT NULL HEIMS Course of Study UID
7 SSR_CRSE_CODE Character(10) VARCHAR2(10) NOT NULL HEIMS Course Code
8 SSR_CRSE_NAME Character(210) VARCHAR2(210) NOT NULL Course Name (HEIMS)
9 SSR_CRSE_STDY_LOAD Number(3,1) DECIMAL(2,1) NOT NULL HEIMS - E350 Course of Study Load (VET)
10 SSR_CRSE_TYPE_CODE Character(2) VARCHAR2(2) NOT NULL HEIMS Course Type Code
11 SSR_STD_CRSE_DUR Number(5,3) DECIMAL(4,3) NOT NULL Standard Course Duration (HEIMS)
12 SSR_CRSE_STDY_TYPE Character(2) VARCHAR2(2) NOT NULL HEIMS Course of Study Type Code
13 SSR_PROVIDER_CODE Character(4) VARCHAR2(4) NOT NULL Provider Code
14 EFFDT_FROM Date(10) DATE Effective Date From
15 EFFDT_TO Date(10) DATE Effective Date To
16 IB_RESTMETHOD Character(10) VARCHAR2(10) NOT NULL REST Method
17 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
18 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
19 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan
20 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
21 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
22 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
23 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
24 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time