| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 3 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 4 |
START_DATE |
Date(10) |
DATE |
Start Date for Gen Standing PO
|
| 5 |
END_DATE |
Date(10) |
DATE |
End Date
|
| 6 |
ALERT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Alert Criterion ID
|
| 7 |
ALERT_NOTIFY_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Notification ID
|
| 8 |
ALERT_RUN_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Alert Run Option; enables time period settings for the Alert generation process, specifically indicating the time span to be covered (current period, or between a specified start and end dates).
C=Current Period
D=Specified Date Range
|
| 9 |
ALERT_SOURCE |
Character(2) |
VARCHAR2(2) NOT NULL |
Alert Source
A=Absence Event
B=Benefit Plan
C=Comp or Leave Time
E=Exceptions
P=Payable Time
R=Reported Time
|
| 10 |
ALERT_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Alert Type
B=Balances
E=Exception
L=Limit
P=Pattern
S=Status
U=Unprocessed Data
V=Data Verification
|
| 11 |
TL_ALERTS_OPER1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Criterion Type
<=is less than
<==is less than or equal to
<>=is not equal to
==is equal to
>=is greater than
>==is greater than or equal to
|
| 12 |
TL_ALERTS_OPER2 |
Character(2) |
VARCHAR2(2) NOT NULL |
Additional Criterion (Or)
<=is less than
<==is less than or equal to
<>=is not equal to
==is equal to
>=is greater than
>==is greater than or equal to
|
| 13 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 14 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 15 |
EOAWUSER_LIST_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Identifies the user list to be used when creating the approval process.
|
| 16 |
EOAWUSER_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
User List Source
C=Application Class
Q=Query
R=Role
S=SQL Definition
|
| 17 |
APP_CLASS |
Character(254) |
VARCHAR2(254) NOT NULL |
Implementation App Class
|
| 18 |
ROLENAME |
Character(30) |
VARCHAR2(30) NOT NULL |
The name of a Role in the Role Definition Table (see PSROLEDEFN).
|
| 19 |
SQLID |
Character(30) |
VARCHAR2(30) NOT NULL |
SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE
SQLTYPE = 0: SQL object name
SQLTYPE = 1: Application Engine Step Identifier
SQLTYPE = 2: RECNAME
SQLTYPE = 6: Application Engine XSLT (XML definition)
|
| 20 |
EXIST |
Character(1) |
VARCHAR2(1) NOT NULL |
Currency Exist
|
| 21 |
ALERT_LIMIT1 |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Numeric (lower) boundary to specify condition when an alert should be triggered.
|
| 22 |
ALERT_LIMIT2 |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Numeric boundary to specify condition when an alert should be triggered.
|
| 23 |
INCL_ML_BRK_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Schedule Totaling
1=Exclude Breaks and Meals
2=Include Meals
3=Include Breaks
4=Include Breaks and Meals
|
| 24 |
PUNCH_TEXT |
Character(75) |
VARCHAR2(75) NOT NULL |
Text
|