OPRIDSCE_IDCAF_SESSION_IDN=No
Y=Yes
RTBL_CAF_CTL_VW(SQL View) |
Index Back |
|---|---|
RTBL CAF Control Table ViewThe RTBL CAF Control Table view joins the RTBL CAF Control Table to the CAF_SESSION table. |
| SELECT CC.OPRID , CC.SCE_ID , CS.CAF_SESSION_ID , CS.CAF_SESSION_NAME , CS.CAF_LAST_FLG , CS.CAF_SAVED_FLG , CS.CAF_PUBLIC_FLG , CC.DEFAULT_FLAG , CC.SELECT_FLAG , CC.LAST_UPDATE_DTTM FROM PS_RTBL_CAF_CONTRL CC , PS_CAF_SESSION CS WHERE CC.OPRID = CS.OPRID AND CC.CAF_SESSION_ID = CS.CAF_SESSION_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | SCE_ID |
Character(10) | VARCHAR2(10) NOT NULL | ID |
| 3 | CAF_SESSION_ID |
Character(36) | VARCHAR2(36) NOT NULL | Session ID |
| 4 | CAF_SESSION_NAME | Character(48) | VARCHAR2(48) NOT NULL | Session Id |
| 5 | CAF_LAST_FLG | Character(1) | VARCHAR2(1) NOT NULL | Last Session |
| 6 | CAF_SAVED_FLG | Character(1) | VARCHAR2(1) NOT NULL | Saved |
| 7 | CAF_PUBLIC_FLG | Character(1) | VARCHAR2(1) NOT NULL | Public |
| 8 | DEFAULT_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Default |
| 9 | SELECT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Selection Flag
N=No Y=Yes |
| 10 | LAST_UPDATE_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |