SCC_DA_ACES_DLG

(SQL Table)
Index Back

DA Txn Setup-Delegator Access

This record has details of Menu/Component that a delegator needs to have access to delegate a transaction.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SCC_DA_TXN_CD Character(50) VARCHAR2(50) NOT NULL Transaction Code
2 SCC_DA_TXN_SEQ Number(3,0) SMALLINT NOT NULL DA Transaction Seq
3 SCC_DA_DELEG_COMP Character(18) VARCHAR2(18) NOT NULL Component Name

Prompt Table: PSPNLGRPDEFN_VW

4 SCC_DA_DELGPG_NAME Character(40) VARCHAR2(40) NOT NULL Page Name

Prompt Table: SCC_DA_PG_D_VW

5 SCC_DA_DELEG_MODE Character(3) VARCHAR2(3) NOT NULL Action Mode
A=Add
C=Correction
E=Data Entry
L=Update/Display All
P=Prompt
U=Update/Display
6 DISPLAYONLY Number(1,0) SMALLINT NOT NULL Display Only

1/0 Table Edit (1=True, 0=False)

7 SCC_DA_DELEG_MENU Character(30) VARCHAR2(30) NOT NULL Pop Select tool menu name field. Used for transfering to the tool's edit page.

Prompt Table: SCC_DA_MENU_DVW

8 SCC_DA_DLG_BARNAME Character(30) VARCHAR2(30) NOT NULL Pop Select tool bar name field. Used for transfering to the tool's edit page.

Prompt Table: SCC_DA_BAR_D_VW

9 SCC_DA_DELEG_ITEM Character(30) VARCHAR2(30) NOT NULL Pop Select tool item name field. Used for transfering to the tool's edit page.

Prompt Table: SCC_DA_ITM_D_VW