| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SCC_TRANSAC_CD |
Character(25) |
VARCHAR2(25) NOT NULL |
Transaction
|
| 2 |
SCC_TRANSACTION |
Character(30) |
VARCHAR2(30) NOT NULL |
Transaction Name
|
| 3 |
SCC_TRNSAC_DESCR |
Character(200) |
VARCHAR2(200) NOT NULL |
Transaction Description
|
| 4 |
SCC_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Status
A=Active
I=Inactive
Default Value: A
|
| 5 |
SCC_SL_TRAN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Stage and Load Transaction Type
B=Batch
R=Realtime
Default Value: R
|
| 6 |
PACKAGEROOT |
Character(30) |
VARCHAR2(30) NOT NULL |
Root Package ID
Prompt Table:
PSPACKAGROOT_VW
|
| 7 |
QUALIFYPATH |
Character(127) |
VARCHAR2(127) NOT NULL |
Qualified Package/Class Path
Prompt Table:
PSPACKAGPATH_VW
|
| 8 |
APPCLASSID |
Character(30) |
VARCHAR2(30) NOT NULL |
Application Class ID
Prompt Table:
PSPACKAGCLAS_VW
|
| 9 |
PNLGRPNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Component Name
Prompt Table:
HCR_SM_RCMP_VW
|
| 10 |
SCC_PRCSNAME |
Character(12) |
VARCHAR2(12) NOT NULL |
Batch Process Name
Prompt Table:
SCC_PRCSDEFN_VW
|
| 11 |
SCC_PROC_SM_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Run SM indicator
Y/N Table Edit
Default Value: Y
|
| 12 |
SCC_SM_RUN_MODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Search Match Run mode
B=Batch
R=Realtime
Default Value: R
|
| 13 |
SCC_RUN_SM_ON_SAVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Run SM on Save
Y/N Table Edit
Default Value: N
|
| 14 |
SCC_SL_PARTITION |
Character(1) |
VARCHAR2(1) NOT NULL |
SnL Partition Strategy
C=By Constituent
T=By Transaction
Default Value: T
|
| 15 |
SCC_PACKAGEROOT |
Character(30) |
VARCHAR2(30) NOT NULL |
Root Package ID
Prompt Table:
SCC_PKG_ROOT_VW
|
| 16 |
SCC_QUALIFYPATH |
Character(127) |
VARCHAR2(127) NOT NULL |
Qualified Package/Class Path
Prompt Table:
SCC_PKG_PATH_VW
|
| 17 |
SCC_APPCLASSID |
Character(30) |
VARCHAR2(30) NOT NULL |
Application Class ID
Prompt Table:
SCC_PKG_CLAS_VW
|
| 18 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table:
PSRECDEFN_VW
|
| 19 |
SCC_DUR_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Data Update Rule
Prompt Table:
SCC_DUR_HDR
|
| 20 |
SCC_NUR_INDICATOR |
Character(1) |
VARCHAR2(1) NOT NULL |
New User regisration Indicator
Y/N Table Edit
Default Value: N
|