| # |
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 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| 4 |
AE_EXISTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Exists
|
| 5 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 6 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
Prompt Table:
SP_BU_GL_NONVW
|
| 7 |
P6_INSTANCE |
Character(30) |
VARCHAR2(30) NOT NULL |
Primavera P6 Instance with wich PeopleSoft integrates
Default Value: P6EPPM
Prompt Table:
P6_INSTANCE_VW
|
| 8 |
P6_TIME_SEND_TO |
Character(2) |
VARCHAR2(2) NOT NULL |
Indicator that determines where timesheet data from Primavera will be sent to (either Expenses or Project Costing).
EX=Expenses
PC=Project Costing
|
| 9 |
P6_AND_OR_1 |
Character(3) |
VARCHAR2(3) NOT NULL |
P6 AND / OR Option
AND=AND
OR=OR
Default Value: AND
|
| 10 |
P6_AND_OR_2 |
Character(3) |
VARCHAR2(3) NOT NULL |
P6 And / Or Option
AND=AND
OR=OR
Default Value: AND
|
| 11 |
P6_TIME_PERIODS |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicators of how many pay periods to process.
1=Current Period
2=Last 2 Periods
3=Last 3 Periods
4=Last 4 Periods
5=Last 5 Periods
|
| 12 |
P6_TIME_WEEKS |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicators of how many weeks to process.
1=Current Week
2=Last 2 Weeks
3=Last 3 Weeks
4=Last 4 Weeks
5=Last 5 Weeks
6=Last 6 Weeks
7=Last 7 Weeks
8=Last 8 Weeks
|
| 13 |
PROJECT_OBJECTID |
Number(10,0) |
DECIMAL(10) NOT NULL |
A unique ID that is the Project key to a corresponding table in an external system such as Primavera.
|
| 14 |
RSRCHOUR_OBJECTID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Primavera P6 timesheet hours unique object id.
|
| 15 |
NUM_PERIODS |
Number(2,0) |
SMALLINT NOT NULL |
Number of Time Periods
|
| 16 |
PERIOD_BEGIN_DT |
Date(10) |
DATE |
Period Begin Date
|
| 17 |
PERIOD_END_DT |
Date(10) |
DATE |
Represents the date termination point for a given time set utilized in cash worksheet processing.
|
| 18 |
BEGIN_DT |
Date(10) |
DATE |
Begin Date
|
| 19 |
END_DT |
Date(10) |
DATE |
End Date
|
| 20 |
RQSTDTTM |
DateTime(26) |
TIMESTAMP |
Request Date/Time
|
| 21 |
END_DAY_OF_PERIOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Ending Day of Period
1=Sunday
2=Monday
3=Tuesday
4=Wednesday
5=Thursday
6=Friday
7=Saturday
|
| 22 |
TIME_RPT_PERIOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Time Report Period
B=Biweekly
D=Daily
S=Semi-Monthly
W=Weekly
|
| 23 |
EMPLID_FROM |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 24 |
EMPLID_TO |
Character(11) |
VARCHAR2(11) NOT NULL |
EmplID
|
| 25 |
COUNT_1 |
Number(3,0) |
SMALLINT NOT NULL |
Count Work Field
|
| 26 |
COUNT_2 |
Number(3,0) |
SMALLINT NOT NULL |
Count Work Field
|
| 27 |
COUNT_3 |
Number(3,0) |
SMALLINT NOT NULL |
Count Work Field
|
| 28 |
COUNT_4 |
Number(3,0) |
SMALLINT NOT NULL |
Count
|
| 29 |
COUNT_5 |
Number(3,0) |
SMALLINT NOT NULL |
Count
|
| 30 |
INTFC_ID |
Number(8,0) |
INTEGER NOT NULL |
Interface ID
|
| 31 |
INTFC_LINE_NUM |
Number(8,0) |
INTEGER NOT NULL |
Interface Line Number
|
| 32 |
ERROR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Error Flag
|
| 33 |
ROW_COUNT |
Number(8,0) |
INTEGER NOT NULL |
Number to Purge
|
| 34 |
NUM_ROWS |
Number(18,0) |
DECIMAL(18) NOT NULL |
Number of Rows
|
| 35 |
NUM_ERRORS |
Number(15,0) |
DECIMAL(15) NOT NULL |
Number of Errors in Data
|
| 36 |
NUM_LINES |
Number(6,0) |
INTEGER NOT NULL |
Total number of demand lines for a particular order satisfying a particular selection criteria on the Fulfillment Status Inquiry Panel.
|
| 37 |
NUM_RECORDS |
Number(15,0) |
DECIMAL(15) NOT NULL |
Number of Records
|
| 38 |
HDR_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Status of Synchronization
010=Complete
020=Error
030=Complete With Warnings
040=Processing
090=Complete With Errors
|
| 39 |
UPPER_LIMIT_ACTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Upper Limit Threshold Action
R=Error
W=Warning
|
| 40 |
LOWER_LIMIT_ACTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Lower Limit Threshold Action
R=Error
W=Warning
|
| 41 |
MAX_HRS_PER_PERIOD |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Maximum Hours Per Period
|
| 42 |
MIN_HRS_PER_PERIOD |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Minimum Hours Per Period
|
| 43 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 44 |
P6_APP_ERR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Error Data
E=Error
F=Fault Error
N=No Errors
R=P6 Response Error
W=Warning
|
| 45 |
P6_TFORM_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Error Data
E=Error
N=No Errors
W=Warning
|
| 46 |
EOTF_MAP_NAME |
Character(150) |
VARCHAR2(150) NOT NULL |
Map Name
|
| 47 |
SQL_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
SQL Type
|
| 48 |
SQL_INSERT_001 |
Character(254) |
VARCHAR2(254) NOT NULL |
|
| 49 |
SQL_TEXT |
Character(254) |
VARCHAR2(254) NOT NULL |
SQL Text
|
| 50 |
SQL_STATEMENT |
Long Character |
CLOB |
SQL Statement
|