| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 UPG_RELEASE |
Character(4) |
VARCHAR2(4) NOT NULL |
Upgrade Application Release
751=7.51 Release
752=7.52 Release
753=7.53 Release
801=8 SP1 Release
803=8 SP3 Release
840=8.40 Release
841=8.40 SP1
880=8.80 Release
|
| 2 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table:
RECDEFN_VW
|
| 3 |
VAT_DRIVER |
Character(15) |
VARCHAR2(15) NOT NULL |
VAT Driver
Prompt Table:
VAT_DRIVER
|
| 4 |
KEY1_FLDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Key 1 Field Name
Prompt Table:
RECFLDDB_VW
|
| 5 |
KEY2_FLDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Key 2 Field Name
Prompt Table:
RECFLDDB_VW
|
| 6 |
KEY3_FLDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Key 3 Field Name
Prompt Table:
RECFLDDB_VW
|
| 7 |
KEY4_FLDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Key 4 Field Name
Prompt Table:
RECFLDDB_VW
|
| 8 |
KEY5_FLDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Key 5 Field Name
Prompt Table:
RECFLDDB_VW
|
| 9 |
EFFDT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
EffDt Flag
N=Effective Date Value
X=No Effective Date
Y=Effective Date in Field
Y/N Table Edit
Default Value: N
|
| 10 |
EFF_STATUS_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status Flag
N=No Effective Status
Y=Effective Status Exists
Y/N Table Edit
Default Value: N
|