| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 RECON_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Reconciliation ID
Prompt Table:
PC_TIP_RECON_VW
|
| 2 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 3 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_PC_NONVW
|
| 4 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table:
SP_PROJPT_NONVW
|
| 5 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
Default Value: PROJ_ACTIVITY.ACTIVITY_ID
Prompt Table:
PROJ_ACT_VW
|
| 6 |
RESOURCE_ID |
Character(40) |
VARCHAR2(40) NOT NULL |
Transaction ID
|
| 7 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PC_EMP_VW
|
| 8 |
RESOURCE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Type
Prompt Table:
PROJ_RES_TYPE
|
| 9 |
RESOURCE_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Category
Prompt Table:
PROJ_CATG_TBL
|
| 10 |
RESOURCE_SUB_CAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Subcategory
Prompt Table:
PROJ_SUBCAT_TBL
|
| 11 |
FROM_DATE |
Date(10) |
DATE |
From Date
|
| 12 |
THRU_DATE |
Date(10) |
DATE |
Through Date
|
| 13 |
DATE_RANGE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Date Option
A=Accounting Date
E=All
T=Transaction Date
Default Value: E
|
| 14 |
PROJECT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Project Status
B=Budgeted
C=Closed
H=Hold
O=Open
P=Proposed
Prompt Table:
PROJ_STAT_VW
|
| 15 |
DAYS_INACT_RANGE |
Character(3) |
VARCHAR2(3) NOT NULL |
Days Inactive Range
-30=< 31
30=31 to 60
60=61 to 90
90+=> 90
A=All
Default Value: A
|
| 16 |
ANALYSIS_GROUP |
Character(5) |
VARCHAR2(5) NOT NULL |
Analysis Group
Prompt Table:
SP_AN_GRP_NONVW
|
| 17 |
PC_TIP_INACTPC |
Character(1) |
VARCHAR2(1) NOT NULL |
Inact Proj w/ unbilled trxns
Y/N Table Edit
Default Value: N
|
| 18 |
PC_TIP_CANOPC |
Character(1) |
VARCHAR2(1) NOT NULL |
Proj. not assigned to Contract
Y/N Table Edit
Default Value: N
|
| 19 |
PC_CA_FEEDER_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Project Source
0=All Sources
1=Projects created in PC
2=Projects created in Grants
Default Value: 0
|
| 20 |
PC_TIP_CANOAC |
Character(1) |
VARCHAR2(1) NOT NULL |
Act. not assigned to Contract
Y/N Table Edit
Default Value: N
|
| 21 |
PC_TIP_FATOPC |
Character(1) |
VARCHAR2(1) NOT NULL |
F&A in Progress
Y/N Table Edit
Default Value: N
|
| 22 |
PC_TIP_GLTOPC |
Character(1) |
VARCHAR2(1) NOT NULL |
Journals in Progress
Y/N Table Edit
Default Value: N
|
| 23 |
PC_TIP_BDTOPC |
Character(1) |
VARCHAR2(1) NOT NULL |
Budgets in Progress
A=Unposted Project Budgets
B=Budgets not distributed to KK
C=Budgets not distributed to PC
|
| 24 |
PC_TIP_BITOPC |
Character(1) |
VARCHAR2(1) NOT NULL |
Billing in Progress
Y/N Table Edit
Default Value: N
|
| 25 |
PC_TIP_ALLTOPC |
Character(1) |
VARCHAR2(1) NOT NULL |
All PC Trxns not Costed/Priced
Y/N Table Edit
Default Value: N
|
| 26 |
PC_TIP_POTOPC |
Character(1) |
VARCHAR2(1) NOT NULL |
Purchase Order in Progress
Y/N Table Edit
Default Value: N
|
| 27 |
PC_TIP_APTOPC |
Character(1) |
VARCHAR2(1) NOT NULL |
Payables in Progress
Y/N Table Edit
Default Value: N
|
| 28 |
PC_TIP_ARTOPC |
Character(1) |
VARCHAR2(1) NOT NULL |
Receivables in Progress
Y/N Table Edit
Default Value: N
|
| 29 |
PC_TIP_REQTOPC |
Character(1) |
VARCHAR2(1) NOT NULL |
Requisitions in Progress
Y/N Table Edit
Default Value: N
|
| 30 |
PC_TIP_UNSPO |
Character(1) |
VARCHAR2(1) NOT NULL |
Unsourced Purchase Orders
Y/N Table Edit
|
| 31 |
PC_TIP_UNSREQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Unsourced Requisitions
Y/N Table Edit
|
| 32 |
PC_TIP_APNOPY |
Character(1) |
VARCHAR2(1) NOT NULL |
Unpaid AP already Dist to PC
Y/N Table Edit
Default Value: N
|
| 33 |
PC_TIP_INTOPC |
Character(1) |
VARCHAR2(1) NOT NULL |
Inventory in Progress
Y/N Table Edit
Default Value: N
|
| 34 |
PC_TIP_EXTOPC |
Character(1) |
VARCHAR2(1) NOT NULL |
Expenses in Progress
Y/N Table Edit
Default Value: N
|
| 35 |
PC_TIP_TMTOPC |
Character(1) |
VARCHAR2(1) NOT NULL |
Time approved in Progress
Y/N Table Edit
Default Value: N
|
| 36 |
SOURCE_OPT_1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Closed
Y/N Table Edit
|
| 37 |
SOURCE_OPT_2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Mass Liquidated
Y/N Table Edit
|
| 38 |
SOURCE_OPT_3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Open
Y/N Table Edit
|
| 39 |
SOURCE_OPT_4 |
Character(1) |
VARCHAR2(1) NOT NULL |
Unavailable for Sourcing
Y/N Table Edit
|
| 40 |
SOURCE_OPT_5 |
Character(1) |
VARCHAR2(1) NOT NULL |
Canceled
Y/N Table Edit
|
| 41 |
SOURCE_OPT_1A |
Character(1) |
VARCHAR2(1) NOT NULL |
Closed
Y/N Table Edit
|
| 42 |
SOURCE_OPT_2A |
Character(1) |
VARCHAR2(1) NOT NULL |
Mass Liquidated
Y/N Table Edit
|
| 43 |
SOURCE_OPT_3A |
Character(1) |
VARCHAR2(1) NOT NULL |
Open
Y/N Table Edit
|
| 44 |
SOURCE_OPT_4A |
Character(1) |
VARCHAR2(1) NOT NULL |
Unavailable for Sourcing
Y/N Table Edit
|
| 45 |
SOURCE_OPT_5A |
Character(1) |
VARCHAR2(1) NOT NULL |
Canceled
Y/N Table Edit
|
| 46 |
GM_METHOD_PAYMENT |
Character(3) |
VARCHAR2(3) NOT NULL |
Method of Payment
CST=Cost Reimbursable
LOC=Letter of Credit
|