HEGIS_CODEEFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
Prompt Table: COUNTRY_TBL
Default Value: HEGIS_CODE_TBL.DESCR
HEGIS_CODE_TBL(SQL Table) |
Index Back |
|---|---|
HEGIS Code TableHEGIS codes is a coding structure defined by the U.S. Education Department which is used by secondary, postsecondary, and adult education institutions to categorize education programs and courses. These codes are used as the basis for much federal, state and district reporting. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HEGIS_CODE |
Character(8) | VARCHAR2(8) NOT NULL | HEGIS Code |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 4 | COUNTRY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Country Code
Prompt Table: COUNTRY_TBL |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL |
Description
Default Value: HEGIS_CODE_TBL.DESCR |