EOATT_MAP_TBL(SQL Table) |
Index Back |
---|
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(4) | VARCHAR2(4) NOT NULL | Product Area | |
2 | Character(2) | VARCHAR2(2) NOT NULL |
Source Mapping
CO=Component PC=Page Composer |
|
3 | Character(100) | VARCHAR2(100) NOT NULL | Level 1 | |
4 | Character(100) | VARCHAR2(100) NOT NULL | Level 2 | |
5 | Character(100) | VARCHAR2(100) NOT NULL | Level 3 | |
6 | 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 |