SCC_DA_TXN_CDA=Active
IA=Inactive
Default Value: Y
Prompt Table: PSROLEDEFN_VW
1/0 Table Edit (1=True, 0=False)
Y/N Table Edit
Prompt Table: SCC_DA_TRNCD_VW
Prompt Table: PSPACKAGROOT_VW
Prompt Table: PSPACKAGPATH_VW
Prompt Table: PSPACKAGCLAS_VW
SCC_DA_TXN_HDR(SQL Table) |
Index Back |
|---|---|
DA Txn SetupHeader Record for DA Txn Setup |
| # | 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_NAME | Character(100) | VARCHAR2(100) NOT NULL | Transaction Name |
| 3 | SCC_DA_LONG_DESCR | Character(250) | VARCHAR2(250) NOT NULL | Description |
| 4 | SCC_DA_TRNCD_STAT | Character(3) | VARCHAR2(3) NOT NULL |
Transaction Status
A=Active IA=Inactive |
| 5 | SCC_DA_DISPDSC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Display Description
Default Value: Y |
| 6 | SCC_DA_MAX_DELEG | Character(4) | VARCHAR2(4) NOT NULL | Maximum Delegate |
| 7 | ROLENAME | Character(30) | VARCHAR2(30) NOT NULL |
The name of a Role in the Role Definition Table (see PSROLEDEFN).
Prompt Table: PSROLEDEFN_VW |
| 8 | DISPLAYONLY | Number(1,0) | SMALLINT NOT NULL |
Display Only
1/0 Table Edit (1=True, 0=False) |
| 9 | SCC_DA_SECKEY_EXP | Number(5,0) | INTEGER NOT NULL | Security key Expiration Days |
| 10 | SCC_DA_EMPCTM_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Assign EMPLID to Proxy?
Y/N Table Edit |
| 11 | SCC_TRANSAC_CD | Character(25) | VARCHAR2(25) NOT NULL |
CTM Transaction Code
Prompt Table: SCC_DA_TRNCD_VW |
| 12 | PACKAGEROOT | Character(30) | VARCHAR2(30) NOT NULL |
Root Package ID
Prompt Table: PSPACKAGROOT_VW |
| 13 | QUALIFYPATH | Character(127) | VARCHAR2(127) NOT NULL |
Qualified Package/Class Path
Prompt Table: PSPACKAGPATH_VW |
| 14 | APPCLASSID | Character(30) | VARCHAR2(30) NOT NULL |
Application Class ID
Prompt Table: PSPACKAGCLAS_VW |