RBQ_QCTMPL_TMP

(SQL Table)
Index Back

Quick Create Template Temp

Quick Create Template Temporary record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ARRAY_ELEMENT Number(3,0) SMALLINT NOT NULL Array Element
2 COUNTRY_NM_FORMAT Character(3) VARCHAR2(3) NOT NULL This is the country name format field.

Prompt Table: COUNTRY_TBL

3 NAME Character(50) VARCHAR2(50) NOT NULL Name
4 NAME_AC Character(50) VARCHAR2(50) NOT NULL Name (Alternate Character)
5 NAME_INITIALS Character(6) VARCHAR2(6) NOT NULL Name Initials
6 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix
7 NAME_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Suffix
8 NAME_ROYAL_PREFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Prefix
9 NAME_ROYAL_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Suffix
10 NAME_TITLE Character(30) VARCHAR2(30) NOT NULL Title
11 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
12 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
13 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
14 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
15 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL Middle Name
16 SECOND_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Second Last Name
17 SECOND_LAST_SRCH Character(30) VARCHAR2(30) NOT NULL Second Name
18 PREF_FIRST_NAME Character(30) VARCHAR2(30) NOT NULL PREF_FIRST_NAME field is used to identify the employees preferred first name
19 NAME_TYPE Character(15) VARCHAR2(15) NOT NULL Business Object Name Type
20 BO_NAME Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object
21 BO_NAME_AC Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object
22 BO_NAME_SHORT Character(10) VARCHAR2(10) NOT NULL Short Name of Business Object
23 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object
24 QC_GROUP Character(1) VARCHAR2(1) NOT NULL GroupBox field
25 QC_GROUP_2 Character(1) VARCHAR2(1) NOT NULL GroupBox field