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