SCC_TRNSAC_VOC(SQL Table) |
Index Back |
|---|---|
Define Vocado TransactionsThe Vocado Transaction setup table |
| # | 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_VOCADO_IND | Character(1) | VARCHAR2(1) NOT NULL |
This is an indicator switch whether the interface to Vocado is turned on/off.
N=No Y=Yes Default Value: N |
| 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_SM_RUN_MODE | Character(1) | VARCHAR2(1) NOT NULL |
Search Match Run mode
B=Batch R=Realtime Default Value: B |