RB_UAD_AGENT(SQL Table) |
Index Back |
---|---|
UAD Agent ConfigurationUnified Agent Desktop Agent Configuration |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: PSOPRDEFN |
2 | BO_NAME | Character(50) | VARCHAR2(50) NOT NULL | Name Description of Business Object |
3 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
4 | WARNING_MINUTE | Number(3,0) | SMALLINT NOT NULL | UAD Warning Minutes |
5 | WARNING_SECS | Number(2,0) | SMALLINT NOT NULL | UAD Warning Seconds |
6 | UADSTYLECLASS_WRN | Character(3) | VARCHAR2(3) NOT NULL |
UAD Style Class
WRN=PSTIMEWARNING |
7 | IMAGE_1 | Character(30) | VARCHAR2(30) NOT NULL |
Image Field
Prompt Table: RC_TB_IMAGE_VW |
8 | IMAGE_FIELD | Image Reference(30) | VARCHAR2(30) | Image Reference Field to display images used in Personalizations explanations. |
9 | EXPIRED_MINUTE | Number(3,0) | SMALLINT NOT NULL | UAD Time out Minutes |
10 | EXPIRED_SECS | Number(2,0) | SMALLINT NOT NULL | UAD Time out Seconds |
11 | UADSTYLECLASS_EXP | Character(3) | VARCHAR2(3) NOT NULL |
UAD Style Class
EXP=PSTIMEEXPIRED |
12 | IMAGE_2 | Character(30) | VARCHAR2(30) NOT NULL |
Display Image
Prompt Table: RC_TB_IMAGE_VW |
13 | RB_IMAGE | Image Reference(30) | VARCHAR2(30) | General purpose image field for displaying images on a page. |
14 | RCDNUM | Number(2,0) | SMALLINT NOT NULL | Record Number |
15 | PHONE_EXT1 | Character(4) | VARCHAR2(4) NOT NULL | Phone Extension 1 |
16 | PHONE_EXT2 | Character(4) | VARCHAR2(4) NOT NULL | Phone Extension 2 |
17 | EXT_DATA_NBR | Number(3,0) | SMALLINT NOT NULL | EXT DATA NBR. This field is used in the TS189 OutBound Transformation Process. |
18 | EC_DTL_LINE_NO | Number(3,0) | SMALLINT NOT NULL | EC Detail Line Number |
19 | DFLT_AGENT_QUEUE | Character(32) | VARCHAR2(32) NOT NULL |
Default UAD Agent Queue
Default Value: RB_UAD_CTIQ_VW.DFLT_AGENT_QUEUE Prompt Table:
RB_UAD_CTIQ_VW
|
20 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
21 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
22 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
23 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
24 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
25 | 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. |
26 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |