| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
INTFC_ID |
Number(8,0) |
INTEGER NOT NULL |
Interface ID
|
| 3 |
INTFC_LINE_NUM |
Number(8,0) |
INTEGER NOT NULL |
Interface Line Number
|
| 4 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_PC_NONVW
|
| 5 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table:
PROJECT_VW
|
| 6 |
INTFC_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Trans Load Type
|
| 7 |
SYSTEM_SOURCE |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies the application or source system that generated a journal entry.
Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values.
SUJ---Included a label as Product.
Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.
|
| 8 |
APPROVAL_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto Approval Status
|
| 9 |
INTFC_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Interface Status
CON=Consolidated
DON=Mass Changes Generated
ERR=Error
NEW=Mass Changes Not Generated
REP=Replaced by Other Records (AP)
UNI=Unitized
|
| 10 |
LOAD_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
/* -> JMZ. PSOFT. 11-OCT-2002 */
New Status were added : HLD and INP for Asset Management.
/* <- JMZ. PSOFT. 11-OCT-2002 */
CON=Consolidated
DON=Loaded
ERR=Errored
EXC=Excluded
HLD=On Hold
INP=In Process
NEW=Pending
PGI=PO Grp Incomplete
REP=Replaced
UNI=Unitized
Default Value: NEW
|
| 11 |
ORIG_INTFC_ID |
Number(8,0) |
INTEGER NOT NULL |
Original Interface ID
|
| 12 |
ORIG_LINE_NUM |
Number(8,0) |
INTEGER NOT NULL |
Original Interface Line Number
|
| 13 |
INTEGRATION_TMPL |
Character(15) |
VARCHAR2(15) NOT NULL |
Integration
Prompt Table:
PC_INT_TMPL
|
| 14 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 15 |
PROJECT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Project Type
A=Activity
G=Grant
H=Phase
P=Project
S=Segment
Prompt Table:
PROJ_TYPE_TBL
|
| 16 |
BUSINESS_UNIT_AM |
Character(5) |
VARCHAR2(5) NOT NULL |
AM Business Unit
Prompt Table:
SP_BU_AM_NONVW
|
| 17 |
ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset Identification
Prompt Table:
PROJ_ASSET_VW
|
| 18 |
PROFILE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Profile ID
Prompt Table:
PROFILE_PCAM_VW
|
| 19 |
GROUP_ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Group Asset ID
|
| 20 |
PARENT_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Parent ID
|
| 21 |
AM_DISTRIB_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
AM Distribution Status
D=Distributed
I=Ignore
M=Modified
N=Not Distributed
P=Pending
V=Reversed
|
| 22 |
TAG_NUMBER |
Character(12) |
VARCHAR2(12) NOT NULL |
Tag Number
|
| 23 |
QUANTITY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Interface
|
| 24 |
TRANS_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Transaction Code
|
| 25 |
TEMPLATE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Project Template
Prompt Table:
PROJECT_TMPL_VW
|
| 26 |
TEMPLATE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Allows the user to indicate whether a given bank transfer transaction should be designated as a
|
| 27 |
AFUDC_PROJ_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Interest Calculation
|
| 28 |
TARGET_PROJ_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Allocation Target
|
| 29 |
SALES_TAX_PROJ_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Sales Tax Calculation
|
| 30 |
DOCKET_NUMBER |
Character(15) |
VARCHAR2(15) NOT NULL |
Docket Number
|
| 31 |
PROJECT_FUNCTION |
Character(10) |
VARCHAR2(10) NOT NULL |
Project Function
|
| 32 |
DTTM_STAMP |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 33 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 34 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|
| 35 |
ADDRESS_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Address ID
|
| 36 |
LOCATION_EFFDT |
Date(10) |
DATE |
Location Effective Date
|
| 37 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 38 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
|
| 39 |
LOCATION_FRACTION |
Number(4,2) |
DECIMAL(3,2) NOT NULL |
Fraction of Cost at Location
|
| 40 |
CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
|
| 41 |
PS_OWNER |
Character(2) |
VARCHAR2(2) NOT NULL |
PeopleSoft Owner
AM=Asset Management
AP=Accounts Payable
AR=Accounts Receivable
BD=Budgets
BI=Billing
CA=Contracts
CM=Cost Management
CS=Customer Service
EN=Engineering
EX=Expenses
GL=General Ledger
HR=Human Resources
IN=Inventory
MG=Manufacturing
OM=Order Management
PC=Project Costing
PL=Planning
PO=Purchasing
PR=Production Control
PT=PeopleTools
TL=Time and Labor
TR=Treasury
|
| 42 |
FLEX_FORMULA |
Character(15) |
VARCHAR2(15) NOT NULL |
Formula Name
|
| 43 |
TEAM_MEMBER |
Character(30) |
VARCHAR2(30) NOT NULL |
Team Member
|
| 44 |
MANAGER_EFFDT |
Date(10) |
DATE |
Project Manager Effective Date
|
| 45 |
PROJECT_MANAGER |
Character(11) |
VARCHAR2(11) NOT NULL |
Project Manager
Prompt Table:
PROJ_MGR_VW
|
| 46 |
ROLE_TYPE |
Character(6) |
VARCHAR2(6) NOT NULL |
Service Type
APR=Approver
MGR=Manager
OPR=Operator
|
| 47 |
MANAGER_START_DT |
Date(10) |
DATE |
Project Manager Start Date
|
| 48 |
MANAGER_END_DT |
Date(10) |
DATE |
Project Manager End Date
|
| 49 |
STATUS_EFFDT |
Date(10) |
DATE |
Project Status Effective Date
|
| 50 |
PROJECT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Project Status
B=Budgeted
C=Closed
H=Hold
O=Open
P=Proposed
|
| 51 |
START_DT |
Date(10) |
DATE |
Start Date
|
| 52 |
END_DT |
Date(10) |
DATE |
End Date
|
| 53 |
PROJECT_PRIORITY |
Number(3,0) |
SMALLINT NOT NULL |
Project Priority
|
| 54 |
PERCENT_COMPLETE |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
% Complete
|
| 55 |
INTEREST_FACTOR |
Signed Number(5,2) |
DECIMAL(3,2) NOT NULL |
Interest Calculation Factor
|
| 56 |
MILESTONE_EFFDT |
Date(10) |
DATE |
Milestone Effective Date
|
| 57 |
MILESTONE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Milestone Type
|
| 58 |
MILESTONE_CODE |
Character(15) |
VARCHAR2(15) NOT NULL |
Milestone Code
|
| 59 |
MILESTONE_ORIGIN |
Character(1) |
VARCHAR2(1) NOT NULL |
Milestone Origin
A=Project
C=Contract
|
| 60 |
TRANS_DT |
Date(10) |
DATE |
Transaction Date
Default Value: %date
|
| 61 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
Default Value: %date
|
| 62 |
SCHEDULE_TYPE |
Character(15) |
VARCHAR2(15) NOT NULL |
Phase Type
|
| 63 |
SCHEDULE_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Schedule Status
A=Actual Schedule
E=Estimated Schedule
|
| 64 |
SCHEDULE_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Project Schedule Description
|
| 65 |
FROM_DT |
Date(10) |
DATE |
From Date
|
| 66 |
TO_DT |
Date(10) |
DATE |
To Date
|
| 67 |
DOCUMENT_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Document Type
123=Lotus 1-2-3
AVI=Video for Windows
CAD=AutoCad Document
DOC=Microsoft Winword
MPP=MicroSoft Project
NON=No Document Type
PST=PeopleSoft PeopleTools
SCR=Lotus ScreenCam
TLP=TimeLine for Windows
TXT=Notepad for ASCII Text
XLS=Microsoft Excel
|
| 68 |
DOCUMENT_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Document Path and Name
|
| 69 |
DOCUMENT_PATH |
Character(80) |
VARCHAR2(80) NOT NULL |
Application Path
|
| 70 |
PROJECT_USER1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Project User 1
|
| 71 |
PROJECT_USER2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Project User 2
|
| 72 |
PROJECT_USER3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Project User 3
|
| 73 |
PROJECT_USER4 |
Character(10) |
VARCHAR2(10) NOT NULL |
Project User 4
|
| 74 |
PROJECT_USER5 |
Character(10) |
VARCHAR2(10) NOT NULL |
Project User 5
|
| 75 |
PROJECT_USER_DT1 |
Date(10) |
DATE |
Date 1
|
| 76 |
PROJECT_USER_DT2 |
Date(10) |
DATE |
Date 2
|
| 77 |
PC_USER_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
User Currency
|
| 78 |
PROJECT_USERAMT1 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Amount 1
|
| 79 |
PROJECT_USERAMT2 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Amount 2
|
| 80 |
PROJECT_USERAMT3 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Amount 3
|
| 81 |
SUMMARY_PRJ |
Character(1) |
VARCHAR2(1) NOT NULL |
An indicator to determine whether project is summary or detail.
N=Detail Project
Y=Program
|