| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 4 |
SCC_TRANSAC_CD |
Character(25) |
VARCHAR2(25) NOT NULL |
Transaction
|
| 5 |
SM_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Search Match Type: This field identifies the domain of core data to be searched.
A=Applicant
O=Organization
P=Person
|
| 6 |
SM_PARM_CD |
Character(15) |
VARCHAR2(15) NOT NULL |
Search Match Parameter Code. This field stores the high level key for a Search Match Parameter definition.
|
| 7 |
SEARCH_RULE_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Search Match Rule Number. This field identifies the Search Order for a specific Search Match Rule within the Search Parameters.
|
| 8 |
SM_RULE_CD |
Character(15) |
VARCHAR2(15) NOT NULL |
Search Match Rule Code. This field stores the high level key for a Search Match Rule definition.
|
| 9 |
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)
|
| 10 |
SCC_SL_SMSET_FROM |
Character(30) |
VARCHAR2(30) NOT NULL |
From Clause
|
| 11 |
SCC_SL_SMSET_WHERE |
Character(30) |
VARCHAR2(30) NOT NULL |
Where Clause
|
| 12 |
PER_ADD_PARM |
Character(1) |
VARCHAR2(1) NOT NULL |
Personal Info - Add Criteria
A=Add
I=Ignore
S=Suspend
U=Update
|
| 13 |
SCC_PER_UPD_PARM |
Character(1) |
VARCHAR2(1) NOT NULL |
Personal Info - Update Criteri
A=Add
I=Ignore
S=Suspend
U=Update
|
| 14 |
SCC_PER_MULT_PARM |
Character(1) |
VARCHAR2(1) NOT NULL |
Personal Info - Multiples Crit
A=Add
I=Ignore
S=Suspend
U=Update
|
| 15 |
SCC_STG_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Staging Status
AN=Add New ID
CN=Cancelled
LD=Loaded
SA=New ID Created
SI=Ignore
SS=Suspended
SU=ID Updated
UE=Update ID
VE=Error
|
| 16 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 17 |
SCC_ID_SELECT |
Character(4) |
VARCHAR2(4) NOT NULL |
ID Selection
ALID=All Temporary IDs
ALLO=All Organization Temporary IDs
ALLP=All Person Temporary IDs
OORG=One Organization Temporary ID
OP=One Person Temporary ID
POP=Population Selection
|
| 18 |
SCC_SUB_RNSM_ONLY |
Character(7) |
VARCHAR2(7) NOT NULL |
SnL run control
Y/N Table Edit
|
| 19 |
SCC_SAVE_RNSM_ONLY |
Character(7) |
VARCHAR2(7) NOT NULL |
SnL run control
Y/N Table Edit
|
| 20 |
SCC_SUB_RUN_SM |
Character(7) |
VARCHAR2(7) NOT NULL |
SnL run control
Y/N Table Edit
Default Value: N
|
| 21 |
SCC_SUB_PST_TRN |
Character(7) |
VARCHAR2(7) NOT NULL |
SnL run control
Y/N Table Edit
Default Value: N
|
| 22 |
SCC_SAVE_SUBMIT |
Character(7) |
VARCHAR2(7) NOT NULL |
SnL run control
Y/N Table Edit
Default Value: N
|
| 23 |
SCC_SAVE_RUN_SM |
Character(7) |
VARCHAR2(7) NOT NULL |
SnL run control
Y/N Table Edit
Default Value: N
|
| 24 |
SCC_SAV_PST_TRN |
Character(7) |
VARCHAR2(7) NOT NULL |
SnL run control
Y/N Table Edit
Default Value: N
|
| 25 |
SCC_TEMP_ID |
Number(16,0) |
DECIMAL(16) NOT NULL |
Temp Constituent ID
|
| 26 |
SCCPS_TOOL_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Tool ID - the unique key for a pop select tool
|
| 27 |
SCCPS_CNTXT_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Context ID - the unique key that identifies the pop selection context
|
| 28 |
SCCPS_QUERY_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Query / Section name used by population selection
|
| 29 |
SCCPS_FILE_PATH |
Character(254) |
VARCHAR2(254) NOT NULL |
Pop Select File Path and Name
|
| 30 |
ATTACHSYSFILENAME |
Character(128) |
VARCHAR2(128) NOT NULL |
Unique Sys Filename
|
| 31 |
SCC_PRCS_SUB_TRNS |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Submitted Transactions
|
| 32 |
SCC_PRCS_SAV_TRNS |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Saved Transactions
|
| 33 |
SCC_SQL_ROW_CNT |
Number(8,0) |
INTEGER NOT NULL |
Sql Row Count
|
| 34 |
SCC_SUSPEND_DUPS |
Character(1) |
VARCHAR2(1) NOT NULL |
Suspend Duplicates
Indicates whether or not duplicate transactions on the input staging table should be suspended.
|
| 35 |
SCC_DUP_RULE |
Character(15) |
VARCHAR2(15) NOT NULL |
Duplicate rule: rule to detect whether an input staging table transaction is among duplicates of itself within the staging table.
|