RAD_SESSION_IDRAD_SAVED_BY1=User Saved
2=System Saved
Default Value: ~
Default Value: ~
C=Compare Station
Q=Question Answer Station
R=Recommendation Station
V=View Station
C=Script Completed
S=Script Saved
RAD_AUD_REC(SQL Table) |
Index Back |
|---|---|
Audit for Record in AdvisorThis record stores the audit for record in advisor |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RAD_SESSION_ID |
Character(20) | VARCHAR2(20) NOT NULL | User Session Identifier |
| 2 | RAD_SAVED_BY |
Character(1) | VARCHAR2(1) NOT NULL |
Saved By
1=User Saved 2=System Saved |
| 3 | RAD_USER_COMP | Character(230) | VARCHAR2(230) NOT NULL |
Advisor User Information compiled information
Default Value: ~ |
| 4 | RAD_CALL_APP_COMP | Character(254) | VARCHAR2(254) NOT NULL |
Advisor Calling Application Information compiled information
Default Value: ~ |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | RAD_ADVISOR_ID | Character(20) | VARCHAR2(20) NOT NULL | Advisor Dialog Guid - represents internally the Advisor dialog |
| 7 | RAD_VERSION_ID | Character(20) | VARCHAR2(20) NOT NULL | Advisor Version Identifier - internally represents a version |
| 8 | RAD_LOG_TS | DateTime(26) | TIMESTAMP | Logging Timestamp |
| 9 | RAD_STATION_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Page type
C=Compare Station Q=Question Answer Station R=Recommendation Station V=View Station |
| 10 | RAD_SCRIPT_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Dialog Status
C=Script Completed S=Script Saved |
| 11 | SYNCID | Number(10,0) | DECIMAL(10) NOT NULL | The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle. |
| 12 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |