CIP_CODEEFFDTDefault Value: %date
LANGUAGE_CDDefault Value: CIP_CODE_TBL.DESCR
CIP_CODE_LANG(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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL |
Description
Default Value: CIP_CODE_TBL.DESCR |
| 6 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |