OPRIDRUN_CNTL_IDCOUNTRY_NM_FORMATPrompt Table: NAME_FMT_CPY_VW
NAME_TYPEPrompt Table: NAME_TYP_CPY_VW
NAME_FIELDNAME_SRCPrompt Table: NAME_CONV_FLDVW
Prompt Table: NAME_PRIM_FLDVW
Y/N Table Edit
Default Value: N
Default Value: 1
RUNCTL_NAME_CPY(SQL Table) |
Index Back |
|---|---|
RUNCTL_NAMETYP_CPY run control |
| # | 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 | COUNTRY_NM_FORMAT |
Character(3) | VARCHAR2(3) NOT NULL |
Supported Name Format Types
Prompt Table: NAME_FMT_CPY_VW |
| 4 | NAME_TYPE |
Character(3) | VARCHAR2(3) NOT NULL |
Type of Name
Prompt Table: NAME_TYP_CPY_VW |
| 5 | NAME_FIELDNAME_SRC |
Character(18) | VARCHAR2(18) NOT NULL |
Source field name.
Prompt Table: NAME_CONV_FLDVW |
| 6 | NAME_FIELDNAME_PRI | Character(18) | VARCHAR2(18) NOT NULL |
Primary name field.
Prompt Table: NAME_PRIM_FLDVW |
| 7 | NAME_UPD_ONLY_BLK | Character(1) | VARCHAR2(1) NOT NULL |
Flag to trigger process change in NAME_FLD_CPY AE process to copy name fields from one type to another only do it when the target field is blank.
Y/N Table Edit Default Value: N |
| 8 | ORDER_SEQ | Number(3,0) | SMALLINT NOT NULL |
Sequence Order for Processing
Default Value: 1 |