INSTITUTIONSSR_ITEM_ATTREFFDTDefault Value: %date
SSR_ITEM_ATTR_VALSSR_ITEM_ATTR_V(SQL Table) |
Index Back |
|---|---|
Attribute Value TableThe Academic Item Attribute Value Table defines the valid values within an Academic Item Attribute. An attribute value must be assigned to each attribute an Academic Item is given. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 2 | SSR_ITEM_ATTR |
Character(10) | VARCHAR2(10) NOT NULL | Academic Item Attribute |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | SSR_ITEM_ATTR_VAL |
Character(20) | VARCHAR2(20) NOT NULL | Attribute Value |
| 5 | DESCRFORMAL | Character(50) | VARCHAR2(50) NOT NULL | Formal Description field |
| 6 | SCC_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Created By |
| 7 | SCC_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Created |
| 8 | SCC_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Updated By |
| 9 | SCC_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Last Update Date/Time |