| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
DTTM_IMPORTED |
DateTime(26) |
TIMESTAMP |
Imported Date Time
|
| 3 |
ATTACHSYSFILENAME |
Character(128) |
VARCHAR2(128) NOT NULL |
Unique Sys Filename
|
| 4 |
ATTACHUSERFILE |
Character(64) |
VARCHAR2(64) NOT NULL |
Attached File
|
| 5 |
NUMBER_OF_FIELDS |
Number(3,0) |
SMALLINT NOT NULL |
Used in Number Management import to control how may fields or header lines are in the imported file.
|
| 6 |
ACCESS_DD_CUST |
Character(1) |
VARCHAR2(1) NOT NULL |
Customer Name
|
| 7 |
ACCESS_DD_FIRST |
Character(1) |
VARCHAR2(1) NOT NULL |
First Name Optional
|
| 8 |
ACCESS_DD_LAST |
Character(1) |
VARCHAR2(1) NOT NULL |
Last Name Optional
|
| 9 |
ACCESS_DD_PHONE |
Character(1) |
VARCHAR2(1) NOT NULL |
Phone Optional
|
| 10 |
ACCESS_DD_ADDR_LIN |
Character(1) |
VARCHAR2(1) NOT NULL |
Address Line 1 Optional
|
| 11 |
ACCESS_DD_CITY |
Character(1) |
VARCHAR2(1) NOT NULL |
City Optional
|
| 12 |
ACCESS_DD_STATE |
Character(1) |
VARCHAR2(1) NOT NULL |
State Optional
|
| 13 |
ACCESS_DD_ZIP |
Character(1) |
VARCHAR2(1) NOT NULL |
Zip Code Optional
|
| 14 |
ACCESS_DD_EMAIL |
Character(1) |
VARCHAR2(1) NOT NULL |
Email
|
| 15 |
ACCESS_DD_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Override of Dup Checking
|