SSR_HE_PLAN_STG(SQL Table) |
Index Back |
---|---|
HESA Plan StageLists HESA Plans and whether the Plan should be included in HESA Reporting. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution | |
2 | Character(10) | VARCHAR2(10) NOT NULL | Academic Plan | |
3 | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
|
4 | Number(3,0) | SMALLINT NOT NULL | Course Stage | |
5 | SSR_HE_ASSACT | Character(1) | VARCHAR2(1) NOT NULL |
Assessment Method
Prompt Table: SSR_HE_KISCDVW5 |
6 | SSR_HE_LTACT | Character(1) | VARCHAR2(1) NOT NULL |
Learning/Teaching Method
Prompt Table: SSR_HE_KISCDVW6 |
7 | SSR_HE_COURSEWORK | Number(3,0) | SMALLINT NOT NULL | Coursework |
8 | SSR_HE_PRACTICAL | Number(3,0) | SMALLINT NOT NULL | Practical Exam |
9 | SSR_HE_WRITTEN | Number(3,0) | SMALLINT NOT NULL | Written Exam |
10 | SSR_HE_INDEPENDENT | Number(3,0) | SMALLINT NOT NULL | Independent Study |
11 | SSR_HE_PLACEMENT | Number(3,0) | SMALLINT NOT NULL | Placement Study |
12 | SSR_HE_SCHEDULED | Number(3,0) | SMALLINT NOT NULL | Scheduled Study |