OPRIDRUN_CNTL_IDSCC_TRANSAC_CDPrompt Table: SCC_TRNSAC_DTLS
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
SCC_PERS_POST(SQL Table) |
Index Back |
|---|---|
Person Post ParmsSCC_PERS_POST holds the parameters needed for the posting of the Constituent data. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | SCC_TRANSAC_CD |
Character(25) | VARCHAR2(25) NOT NULL |
Transaction
Prompt Table: SCC_TRNSAC_DTLS |
| 4 | SCC_RUN_SM_IND | Character(1) | VARCHAR2(1) NOT NULL |
Run Search Match indicator
Y/N Table Edit Default Value: N |
| 5 | SCC_RUN_POST_IND | Character(1) | VARCHAR2(1) NOT NULL |
Run Post Indicator
Y/N Table Edit Default Value: N |
| 6 | SCC_RUN_PURGE_IND | Character(1) | VARCHAR2(1) NOT NULL |
Run Purge Indicator
Y/N Table Edit Default Value: N |
| 7 | TO_DATE | Date(10) | DATE | Latest Date to be sent to PYR |
| 8 | FROM_DATE | Date(10) | DATE | From Date |
| 9 | SCC_COMMIT_FREQ | Number(10,0) | DECIMAL(10) NOT NULL | Commit Frequency |