| # |
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_RECDTLVW
|
| 3 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
Default Value: 1
|
| 4 |
NAME_FRMT_DISPLAY1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Include in Display Name flag.
Y/N Table Edit
Default Value: N
|
| 5 |
NAME_DISPLAY_PSTN |
Number(2,0) |
SMALLINT NOT NULL |
Display Name position number
|
| 6 |
NAME_FRMT_SPC_BFR1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Space Before flag.
Y/N Table Edit
Default Value: N
|
| 7 |
NAME_FRMT_PRE_SEP1 |
Character(3) |
VARCHAR2(3) NOT NULL |
Name field pre-separator.
|
| 8 |
NAME_FRMT_PST_SEP1 |
Character(3) |
VARCHAR2(3) NOT NULL |
Name post separator
|
| 9 |
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
|
| 10 |
NAME_FRMT_DISPLAY2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Include in Formal Name flag.
Y/N Table Edit
Default Value: N
|
| 11 |
NAME_FORMAL_PSTN |
Number(2,0) |
SMALLINT NOT NULL |
Formal Name position number
|
| 12 |
NAME_FRMT_SPC_BFR2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Space Before flag.
Y/N Table Edit
Default Value: N
|
| 13 |
NAME_FRMT_PRE_SEP2 |
Character(3) |
VARCHAR2(3) NOT NULL |
Name field pre-separator.
|
| 14 |
NAME_FRMT_PST_SEP2 |
Character(3) |
VARCHAR2(3) NOT NULL |
Name post separator
|
| 15 |
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
|
| 16 |
NAME_FRMT_DISPLAY3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Inncude in Original Name flag.
Y/N Table Edit
Default Value: N
|
| 17 |
NAME_PSTN |
Number(2,0) |
SMALLINT NOT NULL |
Name position number
|
| 18 |
NAME_FRMT_SPC_BFR3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Space Before flag.
Y/N Table Edit
Default Value: N
|
| 19 |
NAME_FRMT_PRE_SEP3 |
Character(3) |
VARCHAR2(3) NOT NULL |
Name field pre-separator.
|
| 20 |
NAME_FRMT_PST_SEP3 |
Character(3) |
VARCHAR2(3) NOT NULL |
Name post separator
|
| 21 |
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
|
| 22 |
REQUIRED_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Required Flag
Y/N Table Edit
Default Value: N
|
| 23 |
CERTIFIED_BY |
Character(3) |
VARCHAR2(3) NOT NULL |
Certified By
DUE=DUEVO
NEN=NEN
|
| 24 |
SCC_AUTOCOMPLETE |
Character(30) |
VARCHAR2(30) NOT NULL |
Used for capturing autocomplete value
|
| 25 |
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
|