| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
DATETIME_STAMP |
DateTime(26) |
TIMESTAMP |
DateTime Stamp
|
| 3 |
AE_TEST_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Test Flag
|
| 4 |
RECIPIENT_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Payment recipient ID
|
| 5 |
DEP_SCHED_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Deposit Schedule
|
| 6 |
PURPOSE1 |
Character(35) |
VARCHAR2(35) NOT NULL |
Purpose 1
|
| 7 |
PURPOSE2 |
Character(35) |
VARCHAR2(35) NOT NULL |
Purpose 2
|
| 8 |
PIN_NUM |
Number(8,0) |
INTEGER NOT NULL |
PIN Number
|
| 9 |
DUMMY_FIELD |
Character(1) |
VARCHAR2(1) NOT NULL |
Dummy Field
|
| 10 |
COUNTER |
Number(10,0) |
DECIMAL(10) NOT NULL |
Counter
|
| 11 |
DUMMY_KEY_NUM |
Number(11,0) |
DECIMAL(11) NOT NULL |
Dummy Key
|
| 12 |
CAL_RUN_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Calendar Run Id
|
| 13 |
GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Global Payroll pay group
|
| 14 |
CAL_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
calendar id
|
| 15 |
STRING_TEXT |
Character(100) |
VARCHAR2(100) NOT NULL |
String Text
|
| 16 |
COMMENTS |
Long Character |
CLOB |
Comment
|
| 17 |
PIN_CODE |
Character(22) |
VARCHAR2(22) NOT NULL |
Unique identifier of a PIN (alternate to PIN number). critical for use in merging packages of elements from one database onto another when PINs may or may not be renumbered as they are moved across.
Constructed from PIN_NM + COUNTRY of the element definition (GP_PIN)
|
| 18 |
EMPLID_FROM |
Character(11) |
VARCHAR2(11) NOT NULL |
EMPLID (first for a range)
|
| 19 |
EMPLID_TO |
Character(11) |
VARCHAR2(11) NOT NULL |
EmplID To
|
| 20 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 21 |
GP_RSLT_ACUM_CNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
This field is used on the state record on the upgrade application engine program UPG_GP.
|
| 22 |
UPG_RELEASE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Release Number. Used in upgrade by UPG_RENAMED_PIN record.
|