INSTITUTIONMILESTONEEFFDTDefault Value: %date
Prompt Table: SSR_NQF_FIELD
Prompt Table: SSR_NQF_SUBFLD
Prompt Table: SSR_NQF_DOMAIN
ENG=English
MAO=Maori
U=Unit Standard
SSR_MILESTN_NZL(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 2 | MILESTONE |
Character(10) | VARCHAR2(10) NOT NULL | Milestone |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | SSR_NQF_VERSION | Character(2) | VARCHAR2(2) NOT NULL | Unit Standard Version |
| 5 | SSR_NQF_FLD_CD | Character(3) | VARCHAR2(3) NOT NULL |
Unit Standard Field Code
Prompt Table: SSR_NQF_FIELD |
| 6 | SSR_NQF_SUBFLD_CD | Character(3) | VARCHAR2(3) NOT NULL |
Unit Standard Subfield Code
Prompt Table: SSR_NQF_SUBFLD |
| 7 | SSR_NQF_DOMAIN_CD | Character(3) | VARCHAR2(3) NOT NULL |
Unit Standard Domain Code
Prompt Table: SSR_NQF_DOMAIN |
| 8 | SSR_NQF_LANGUAGE | Character(3) | VARCHAR2(3) NOT NULL |
Unit Standard Language
ENG=English MAO=Maori |
| 9 | SSR_NQF_CREDIT | Number(3,0) | SMALLINT NOT NULL | The credit value of the course on the National Qualification Framework. |
| 10 | SSR_MLSTN_TYP | Character(1) | VARCHAR2(1) NOT NULL |
Flag to differentiate between different types of milestone
U=Unit Standard |