NAME_FLDCPY_AET(SQL Table) |
Index Back |
---|---|
NAME_FLD_CPY state record |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | ORDER_SEQ | Number(3,0) | SMALLINT NOT NULL |
Sequence Order for Processing
Default Value: 1 |
3 | COUNTRY_NM_FORMAT | Character(3) | VARCHAR2(3) NOT NULL | Supported Name Format Types |
4 | NAME_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Type of Name |
5 | NAME_FIELDNAME_SRC | Character(18) | VARCHAR2(18) NOT NULL | Source field name. |
6 | NAME_FIELDNAME_PRI | Character(18) | VARCHAR2(18) NOT NULL | Primary name field. |
7 | CURR_DATE | Date(10) | DATE | Current Date - use for processing |
8 | 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 |
9 | NAME_CONV_ON_BLANK | Character(40) | VARCHAR2(40) NOT NULL | Used in the NAME_FLD_CPY name conversion AE to hold the sql for when only blank name values should be updated. |
10 | NAME_CONV_LN_BLANK | Character(50) | VARCHAR2(50) NOT NULL | used in the NAME_FLD_CPY name conversion AE to hold the sql for when only blank name values should be updated on the language table. |
11 | CONTINUE_AE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Continue AE Processing flag |