EOATT_MAP_TBL(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EOATT_PRODUCT |
Character(4) | VARCHAR2(4) NOT NULL | Product Area |
| 2 | EOATT_SRC_MAP |
Character(2) | VARCHAR2(2) NOT NULL |
Source Mapping
CO=Component PC=Page Composer |
| 3 | EOATT_LEVEL1 |
Character(100) | VARCHAR2(100) NOT NULL | Level 1 |
| 4 | EOATT_LEVEL2 |
Character(100) | VARCHAR2(100) NOT NULL | Level 2 |
| 5 | EOATT_LEVEL3 |
Character(100) | VARCHAR2(100) NOT NULL | Level 3 |
| 6 | EOATT_LEVEL4 |
Character(100) | VARCHAR2(100) NOT NULL | Level 4 |
| 7 | EOATT_CONFIG_ID1 | Character(20) | VARCHAR2(20) NOT NULL | Configuration ID 1 |
| 8 | EOATT_VISIBLITY1 | Character(1) | VARCHAR2(1) NOT NULL |
View Mode 1
0=Comments and Attachments 1=Comments 2=Attachments Default Value: 0 |
| 9 | EOATT_CONFIG_ID2 | Character(20) | VARCHAR2(20) NOT NULL | Configuration ID 2 |
| 10 | EOATT_VISIBLITY2 | Character(1) | VARCHAR2(1) NOT NULL |
View Mode 2
0=Comments and Attachments 1=Comments 2=Attachments Default Value: 0 |
| 11 | EOATTUSER_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
User List Source
C=Application Class Q=Query R=Role S=SQL Definition Default Value: R |
| 12 | QRYNAME | Character(30) | VARCHAR2(30) NOT NULL | Query Name |
| 13 | SQLID | Character(30) | VARCHAR2(30) NOT NULL |
SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE |
| 14 | ROLENAME | Character(30) | VARCHAR2(30) NOT NULL | The name of a Role in the Role Definition Table (see PSROLEDEFN). |
| 15 | PACKAGEROOT | Character(30) | VARCHAR2(30) NOT NULL | Root Package ID |
| 16 | APPCLASS_PATH | Character(254) | VARCHAR2(254) NOT NULL | Application Class Full Path |
| 17 | EOATT_APPCL_METHOD | Character(100) | VARCHAR2(100) NOT NULL | App Class Method |
| 18 | EOATT_ULIST_ACCESS | Character(1) | VARCHAR2(1) NOT NULL |
Access Type
0=Comments and Attachments 1=Comments 2=Attachments Default Value: 0 |
| 19 | EOATT_EXTLST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Name of file extension list |
| 20 | EOATT_FXACTION | Character(1) | VARCHAR2(1) NOT NULL |
Action
D=Display Only H=Hide Row Default Value: D |