CIP_CODEEFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
Default Value: CIP_CODE_TBL.DESCR
CIP_CODE90_TBL(SQL Table) |
Index Back |
|---|---|
CIP 1990 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. This record is a backup of the CIP_CODE_TBL before the record structure was changed to accomodate CIP 2000 codes. |
| # | 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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL |
Description
Default Value: CIP_CODE_TBL.DESCR |