SSR_HE_MODE_STD(SQL Table) |
Index Back |
---|---|
Mode of Study Mappings |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
2 | ACAD_LOAD_APPR | Character(1) | VARCHAR2(1) NOT NULL |
Approved Academic Load
B=Vocational Coaching (NLD) D=Dual (NLD) E=Part-time Vocational Tr (NLD) F=Full-Time O=Vocational Training (NLD) P=Part-Time Prompt Table: SSR_HE_MODSTUVW |
3 | SSR_HE_MODE_STUDY | Character(30) | VARCHAR2(30) NOT NULL |
HESA Mode of Study
Prompt Table: SSR_HE_CODE_VW |
4 | SSR_HE_ACTIVE | Character(1) | VARCHAR2(1) NOT NULL |
Active
Y/N Table Edit Default Value: Y |
5 | SSR_HE_CRSDELMODE | Character(2) | VARCHAR2(2) NOT NULL |
Delivery Mode
Prompt Table: SSR_HE_CDLMD_VW |
6 | SSR_HE_SESS_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Session Status
Prompt Table: SSR_HE_SESST_VW |
7 | SSR_HE_SESS_MODE | Character(2) | VARCHAR2(2) NOT NULL |
HESA Session Mode
Prompt Table: SSR_HE_SESMD_VW |