RUN_CNTL_GP(SQL Table) |
Index Back |
|---|---|
Run Control Group Load |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_CS.OPRID |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | SSF_ERROR_WARN | Character(1) | VARCHAR2(1) NOT NULL |
Field to hold translate values for Message Types - Error/Warning/Message
E=Error M=Message W=Warning |
| 4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT Prompt Table: SP_BU_SF_NONVW |
| 5 | GROUP_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Group Type
Prompt Table: GROUP_TYPE_TBL |
| 6 | FILENAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |
| 7 | FILEDIR | Character(40) | VARCHAR2(40) NOT NULL | File Directory |
| 8 | BALANCE_GRP | Character(1) | VARCHAR2(1) NOT NULL |
Balance the Group
Y/N Table Edit Default Value: N |
| 9 | RECON_LAYOUT_ID | Character(8) | VARCHAR2(8) NOT NULL |
Input File Layout ID
Prompt Table: BNK_RCN_INP_VW |
| 10 | SF_REVERSAL_IND | Character(1) | VARCHAR2(1) NOT NULL | Reversal Indicator |
| 11 | RPT_ONLY | Character(1) | VARCHAR2(1) NOT NULL |
Report Only
N=No Y=Yes Y/N Table Edit |
| 12 | SF_SEQ_NO | Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 13 | EMPLID_SW1 | Character(1) | VARCHAR2(1) NOT NULL |
Emplid Switch
E=By Emplid O=By Org ID Default Value: E |
| 14 | SSF_RESTRICT_INV | Character(1) | VARCHAR2(1) NOT NULL |
This field indicates that the payment will be held until an invoice is provided.
Y/N Table Edit Default Value: N |