EOATT_MAPPC_VW

(SQL View)
 Index Back

SELECT EOATT_PRODUCT , EOATT_SRC_MAP , EOATT_LEVEL1 , EOATT_LEVEL2 , EOATT_LEVEL3 , EOATT_LEVEL4 , EOATT_CONFIG_ID1 , EOATT_VISIBLITY1 , EOATT_CONFIG_ID2 , EOATT_VISIBLITY2 , EOATTUSER_SOURCE , QRYNAME , SQLID , ROLENAME , PACKAGEROOT , APPCLASS_PATH , EOATT_APPCL_METHOD , EOATT_ULIST_ACCESS , EOATT_EXTLST_NAME , EOATT_FXACTION FROM PS_EOATT_MAP_TBL WHERE EOATT_SRC_MAP = 'PC'

# 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

Default Value: PC

3 EOATT_LEVEL1 Character(100) VARCHAR2(100) NOT NULL Level 1

Prompt Table: EOATT_EOAWTXNVW

4 EOATT_LEVEL2 Character(100) VARCHAR2(100) NOT NULL Level 2

Prompt Table: EOATT_EOPCPG_VW

5 EOATT_LEVEL3 Character(100) VARCHAR2(100) NOT NULL Level 3

Prompt Table: EOAWUSER_LIST

6 EOATT_LEVEL4 Character(100) VARCHAR2(100) NOT NULL Level 4

Prompt Table: %EDITTABLE4

7 EOATT_CONFIG_ID1 Character(20) VARCHAR2(20) NOT NULL Configuration ID 1

Prompt Table: EOATT_CFG_ID_VW

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

Prompt Table: EOATT_CFG_ID_VW

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

Prompt Table: QRY_NAME_VW

13 SQLID Character(30) VARCHAR2(30) NOT NULL SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE
  • SQLTYPE = 0: SQL object name
  • SQLTYPE = 1: Application Engine Step Identifier
  • SQLTYPE = 2: RECNAME
  • SQLTYPE = 6: Application Engine XSLT (XML definition)

    Prompt Table: EOAW_SQLID_VW

    • 14 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).

    Prompt Table: PSROLEDEFN_VW

    15 PACKAGEROOT Character(30) VARCHAR2(30) NOT NULL Root Package ID

    Prompt Table: EOAWPACKAGE_VW

    16 APPCLASS_PATH Character(254) VARCHAR2(254) NOT NULL Application Class Full Path

    Prompt Table: EOAWAPCLSPTH_VW

    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

    Prompt Table: PTFX_EXTLSTDEFN

    20 EOATT_FXACTION Character(1) VARCHAR2(1) NOT NULL Action
    D=Display Only
    H=Hide Row

    Default Value: D