OPRIDCAF_SESSION_IDRTBL=Real Time Bottom Line
SYS=System
USER=User Defined
A=Analysis
C=Comparison
Default Value: C
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
CAF_SESSION(SQL Table) |
Index Back |
|---|
| # | 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 | CAF_SESSION_ID |
Character(36) | VARCHAR2(36) NOT NULL | Session ID |
| 3 | CAF_SESSION_NAME | Character(48) | VARCHAR2(48) NOT NULL | Session Id |
| 4 | CAF_CONFIG_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Analysis Type
RTBL=Real Time Bottom Line SYS=System USER=User Defined |
| 5 | CAF_CONFIG_ID | Character(30) | VARCHAR2(30) NOT NULL | Analysis ID |
| 6 | CAF_ANALYSIS_MODE | Character(1) | VARCHAR2(1) NOT NULL |
Analysis Mode
A=Analysis C=Comparison Default Value: C |
| 7 | CAF_HASH | Character(28) | VARCHAR2(28) NOT NULL | Hash |
| 8 | CAF_SAVED_FLG | Character(1) | VARCHAR2(1) NOT NULL | Saved |
| 9 | CAF_PUBLIC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Public
Y/N Table Edit Default Value: N |
| 10 | CAF_LAST_FLG | Character(1) | VARCHAR2(1) NOT NULL | Last Session |
| 11 | CAF_EXPIRATION_DT | Date(10) | DATE | Expiration Date |
| 12 | CAF_DELETE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Delete
Y/N Table Edit Default Value: N |
| 13 | CAF_SESSION_ID_ORI | Character(36) | VARCHAR2(36) NOT NULL | Original Session ID |
| 14 | CAF_GD_FROM | Date(10) | DATE | Global Date from |
| 15 | CAF_GD_TO | Date(10) | DATE | Global Date to |