SSR_HM_COURSE(SQL Table) |
Index Back |
---|---|
HEIMS CourseHEIMS 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 |