SSR_AC_INCL_TYPEA=Active
I=Inactive
SSR_AC_INCLTVW2(SQL View) |
Index Back |
|---|---|
Activity Inclusion View |
| SELECT SSR_AC_INCL_TYPE ,EFF_STATUS ,SSR_ACM_SORT_ORD , DESCR , SCC_ROW_ADD_OPRID ,SCC_ROW_ADD_DTTM ,SCC_ROW_UPD_OPRID , SCC_ROW_UPD_DTTM FROM PS_SSR_AC_INCLTYPE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SSR_AC_INCL_TYPE |
Character(10) | VARCHAR2(10) NOT NULL | Inclusion Type |
| 2 | SSR_EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 3 | SSR_ACM_SORT_ORD | Number(4,0) | SMALLINT NOT NULL | Sort Sequence |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | SCC_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Created By |
| 6 | SCC_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Created |
| 7 | SCC_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Updated By |
| 8 | SCC_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Last Update Date/Time |