UPG_CDMNAME_AET

(SQL Table)
Index Back

For UPG_CDM

UPG_CDMNAME_AET - Used in CDM Upgrade AE Program as a temp Table.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
3 SOURCE_IND Character(4) VARCHAR2(4) NOT NULL EIP Source Indicator
CRM=CRM
EBS=EBIZ Suite
EXT=External
HRMS=HCM
SCM=SCM
4 COUNTRY_NM_FORMAT Character(3) VARCHAR2(3) NOT NULL This is the country name format field.
5 NAME Character(50) VARCHAR2(50) NOT NULL Name
6 NAME_INITIALS Character(6) VARCHAR2(6) NOT NULL Name Initials
7 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix
8 NAME_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Suffix
9 NAME_ROYAL_PREFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Prefix
10 NAME_ROYAL_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Suffix
11 NAME_TITLE Character(30) VARCHAR2(30) NOT NULL Title
12 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
13 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
14 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
15 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
16 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL Middle Name
17 SECOND_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Second Last Name
18 SECOND_LAST_SRCH Character(30) VARCHAR2(30) NOT NULL Second Name
19 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object