CIP_CODEEFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
Prompt Table: COUNTRY_TBL
Y/N Table Edit
Default Value: N
CIP_CODE_TBL(SQL Table) |
Index Back |
|---|---|
CIP TableCIP (Classification of Instructional Program) 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 | CIP_CODE |
Character(13) | VARCHAR2(13) NOT NULL | CIP 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 | CIP_ALTERNATIVE_CD | Character(13) | VARCHAR2(13) NOT NULL | Alternative CIP Code |
| 5 | CIP_ALTERNATIV_CD2 | Character(13) | VARCHAR2(13) NOT NULL | CIP 2000 |
| 6 | COUNTRY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Country Code
Prompt Table: COUNTRY_TBL |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 8 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 9 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 10 | SEV_VALID_CIP_CD | Character(1) | VARCHAR2(1) NOT NULL |
This is a Yes/No flag to denote whether or not the CIP code is valid from a SEVIS perspective. This field is germain only to US Schools.
Y/N Table Edit Default Value: N |