| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 COUNTRY_NM_FORMAT |
Character(3) |
VARCHAR2(3) NOT NULL |
Supported Name Format Types
|
| 2 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table:
NAME_FLDS_VW
|
| 3 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
Default Value: 1
|
| 4 |
NAME_GROUP_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates which name group a name field is used in:
D - Display
F - Formal
D=Display Name Group
F=Formal Name Group
Default Value: F
|
| 5 |
PREF_NAME_DFLT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to indicate whether or not to default the preferred name field value to the corresponding name field value, if empty.
Y/N Table Edit
Default Value: N
|
| 6 |
NAME_FRMT_DISPLAY1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Include in Display Name flag.
Y/N Table Edit
Default Value: N
|
| 7 |
NAME_DISPLAY_PSTN |
Number(2,0) |
SMALLINT NOT NULL |
Display Name position number
|
| 8 |
NAME_FRMT_SPC_BFR1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Space Before flag.
Y/N Table Edit
Default Value: N
|
| 9 |
NAME_FRMT_PRE_SEP1 |
Character(3) |
VARCHAR2(3) NOT NULL |
Name field pre-separator.
|
| 10 |
NAME_FRMT_PST_SEP1 |
Character(3) |
VARCHAR2(3) NOT NULL |
Name post separator
|
| 11 |
NAME_FRMT_DSP_TYP1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Display type for name prefixes, suffixes and titles when they are used in a display name field (NAME_DISPLAY, NAME_FORMAL or NAME):
V - Value (code) (default)
S - Short Description
L - Long Description
L=Long Description
S=Short Description
V=Value
Default Value: V
|
| 12 |
NAME_FRMT_DISPLAY2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Include in Formal Name flag.
Y/N Table Edit
Default Value: N
|
| 13 |
NAME_FORMAL_PSTN |
Number(2,0) |
SMALLINT NOT NULL |
Formal Name position number
|
| 14 |
NAME_FRMT_SPC_BFR2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Space Before flag.
Y/N Table Edit
Default Value: N
|
| 15 |
NAME_FRMT_PRE_SEP2 |
Character(3) |
VARCHAR2(3) NOT NULL |
Name field pre-separator.
|
| 16 |
NAME_FRMT_PST_SEP2 |
Character(3) |
VARCHAR2(3) NOT NULL |
Name post separator
|
| 17 |
NAME_FRMT_DSP_TYP2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Display type for name prefixes, suffixes and titles when they are used in a display name field (NAME_DISPLAY, NAME_FORMAL or NAME):
V - Value (code) (default)
S - Short Description
L - Long Description
L=Long Description
S=Short Description
V=Value
Default Value: V
|
| 18 |
NAME_FRMT_DISPLAY3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Inncude in Original Name flag.
Y/N Table Edit
Default Value: N
|
| 19 |
NAME_PSTN |
Number(2,0) |
SMALLINT NOT NULL |
Name position number
|
| 20 |
NAME_FRMT_SPC_BFR3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Space Before flag.
Y/N Table Edit
Default Value: N
|
| 21 |
NAME_FRMT_PRE_SEP3 |
Character(3) |
VARCHAR2(3) NOT NULL |
Name field pre-separator.
|
| 22 |
NAME_FRMT_PST_SEP3 |
Character(3) |
VARCHAR2(3) NOT NULL |
Name post separator
|
| 23 |
NAME_FRMT_DSP_TYP3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Display type for name prefixes, suffixes and titles when they are used in a display name field (NAME_DISPLAY, NAME_FORMAL or NAME):
V - Value (code) (default)
S - Short Description
L - Long Description
L=Long Description
S=Short Description
V=Value
Default Value: V
|
| 24 |
NAME_FRMT_DISPLAY4 |
Character(1) |
VARCHAR2(1) NOT NULL |
Inncude in Original Name flag.
Y/N Table Edit
Default Value: N
|
| 25 |
NAME_FRMLPSF_PSTN |
Number(2,0) |
SMALLINT NOT NULL |
Name position number
|
| 26 |
NAME_FRMT_SPC_BFR4 |
Character(1) |
VARCHAR2(1) NOT NULL |
Space Before flag.
Y/N Table Edit
Default Value: N
|
| 27 |
NAME_FRMT_PRE_SEP4 |
Character(3) |
VARCHAR2(3) NOT NULL |
Name field pre-separator.
|
| 28 |
NAME_FRMT_PST_SEP4 |
Character(3) |
VARCHAR2(3) NOT NULL |
Name post separator
|
| 29 |
NAME_FRMT_DSP_TYP4 |
Character(1) |
VARCHAR2(1) NOT NULL |
Display type for name prefixes, suffixes and titles when they are used in a display name field (NAME_DISPLAY, NAME_FORMAL or NAME):
V - Value (code) (default)
S - Short Description
L - Long Description
L=Long Description
S=Short Description
V=Value
Default Value: V
|
| 30 |
REQUIRED_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Required Flag
Y/N Table Edit
Default Value: N
|
| 31 |
CERTIFIED_BY |
Character(3) |
VARCHAR2(3) NOT NULL |
Certified By
DUE=DUEVO
NEN=NEN
|
| 32 |
SYSTEM_DATA_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.
Y/N Table Edit
Default Value: N
|