| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
DATETIME_STAMP |
DateTime(26) |
TIMESTAMP |
DateTime Stamp
|
| 4 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 5 |
AE_STEP |
Character(8) |
VARCHAR2(8) NOT NULL |
Name
|
| 6 |
PGM_FLOW_CNTL |
Character(1) |
VARCHAR2(1) NOT NULL |
Convenient AE State Record field for receiving result of a Do-When, Do-While, Do-Until, or other program flow control flag.
|
| 7 |
SQL_ROW_COUNT |
Number(8,0) |
INTEGER NOT NULL |
Convenient AE State Record field for managing the count of affected rows when %SQLRows is not applicable.
|
| 8 |
RESULT_CD |
Number(3,0) |
SMALLINT NOT NULL |
Convenient AE State Record field for managing the Return Code from a PeopleCode Call.
|
| 9 |
MESSAGE_SET_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
|
| 10 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
|
| 11 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 12 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 13 |
EFFDT |
Date(10) |
DATE |
Effective Date
|
| 14 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 15 |
EP_ITEM_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Item unique identifier
|
| 16 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 17 |
COMPETENCY |
Character(8) |
VARCHAR2(8) NOT NULL |
Competency
|
| 18 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 19 |
EP_DESCR254 |
Long Character(1325) |
VARCHAR2(1325) |
1325 character description field used in ePerformance
|
| 20 |
EP_REVIEWER_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Reviewer ID
|
| 21 |
HR_NP_SUBJECT |
Character(50) |
VARCHAR2(50) NOT NULL |
HR Notepad: Subject of note.
|
| 22 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|