ACTIVITY_LISTPA_ACTIVITY_CDPA_RT_ACT_VW(SQL View) |
Index Back |
|---|---|
View for Activity ListThis is a working view for Activity List. |
| select activity_list, pa_activity_cd, descr from PS_PA_RT_ACTIVITY |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ACTIVITY_LIST |
Character(10) | VARCHAR2(10) NOT NULL | Activity List |
| 2 | PA_ACTIVITY_CD |
Character(4) | VARCHAR2(4) NOT NULL | Activity Code |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |