HRS_LST_IDHRS_LIST_NM_VW(SQL View) |
Index Back |
|---|
| SELECT HRS_LST_ID , HRS_OWNER_ID , HRS_LST_NAME , HRS_LST_PUBLIC FROM PS_HRS_LIST_VW WHERE HRS_LST_ACTIVE = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_LST_ID |
Number(15,0) | DECIMAL(15) NOT NULL | List ID |
| 2 | HRS_OWNER_ID | Character(11) | VARCHAR2(11) NOT NULL | Owner ID |
| 3 | HRS_LST_NAME | Character(50) | VARCHAR2(50) NOT NULL | List Name |
| 4 | HRS_LST_PUBLIC | Character(1) | VARCHAR2(1) NOT NULL | Share with Others? |