| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 ASSIGNMENT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Work Assignment ID
Default Value: NEXT
|
| 2 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
RS_WRKR_ADD_VW
|
| 3 |
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.
Default Value: RS
|
| 4 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_PC_NONVW
|
| 5 |
SO_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Service Order ID
Prompt Table:
%EDITTABLE2
|
| 6 |
SO_LINE |
Number(3,0) |
SMALLINT NOT NULL |
Line Number
Prompt Table:
RS_ASSGN_OSL_VW
|
| 7 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table:
%EDITTABLE5
|
| 8 |
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.
Prompt Table:
RS_CUSTOMER_VW
|
| 9 |
REPLACED_ASGN_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Work Assignment ID
Prompt Table:
FO_ASGN_SRC_VW2
|
| 10 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
|
| 11 |
CONTRACT_LINE_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Contract Line Num
|
| 12 |
ASSIGNMENT_ID2 |
Character(15) |
VARCHAR2(15) NOT NULL |
Assignment ID
|
| 13 |
ENTERED_BY |
Character(30) |
VARCHAR2(30) NOT NULL |
Entered by
|
| 14 |
DTTM_ENTERED |
DateTime(26) |
TIMESTAMP |
Date Time Stamp for Entry
|
| 15 |
LASTUPDOPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 16 |
LASTUPDDTTM |
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.
|
| 17 |
END_ACTUAL_DATE |
Date(10) |
DATE |
Actual End Date
|
| 18 |
END_ACTUAL_REASON |
Character(2) |
VARCHAR2(2) NOT NULL |
End Reason
C1=Cancelled: Rate too High
C2=Cancelled: Slow in Response
C3=Cancelled: Job Delayed
C4=Cancelled: Order Not Needed
C5=Cancelled: Unknown or Other
CF=Competitor Filled Position
D1=Declined: Work Hazard
D2=Declined: Credit Problem
D3=Declined: Undesirable
D4=Declined: Unknown or Other
E1=Employee Dissatisfaction
F1=Unable to Fill: Candidate N/A
F2=Unable to Fill: Skills N/A
F3=Unable to Fill: Undesirable
FP=Filled Position
IC=Inquiry Closed
OC=Order Closed
OT=Other Reason
S1=Satisfactory: Work Completed
U1=Unsatisfactory: Employee Perf
U2=Unsatisfactory: Employ No Show
|
| 19 |
END_ACTUAL_COMMENT |
Character(254) |
VARCHAR2(254) NOT NULL |
End Comment
|
| 20 |
EMPL_RCD_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Project Employee Job Record #
|
| 21 |
NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Name
|
| 22 |
FEE_SCHEDULE |
Character(50) |
VARCHAR2(50) NOT NULL |
Fee Schedule
Prompt Table:
FO_POTENTIAL_VW
Set Control Field: BUSINESS_UNIT
|
| 23 |
SCHEDULE_COMMENT |
Character(254) |
VARCHAR2(254) NOT NULL |
Comment
|
| 24 |
FEE_SCHEDULE_SENT |
Date(10) |
DATE |
Fee Schedule Sent
|
| 25 |
FEE_SCHEDULE_SIGN |
Date(10) |
DATE |
Fee Schedule Sign
|
| 26 |
GUARANTEE_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Guarantee Days
|
| 27 |
SALARY |
Number(12,3) |
DECIMAL(11,3) NOT NULL |
Salary Accepted
|
| 28 |
COMPENSATION |
Number(12,3) |
DECIMAL(11,3) NOT NULL |
Compensation
|
| 29 |
ACTUAL_FEE |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Actual Fee Pct
|
| 30 |
INCOME |
Number(11,3) |
DECIMAL(10,3) NOT NULL |
Income
|
| 31 |
DEPTID_REV |
Character(10) |
VARCHAR2(10) NOT NULL |
Career Rev Department
Prompt Table:
FO_DEPTID_VW
Set Control Field: BUSINESS_UNIT
|
| 32 |
FO_FALL_OFF |
Character(1) |
VARCHAR2(1) NOT NULL |
Fall Off
Y/N Table Edit
Default Value: N
|
| 33 |
FALL_OFF_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Fall Off Code
Prompt Table:
FO_FALL_OFF_VW
Set Control Field: BUSINESS_UNIT
|
| 34 |
DAYS_WORKED |
Number(4,0) |
SMALLINT NOT NULL |
Number of Days Worked
|
| 35 |
FALL_OFF_AMT |
Number(11,3) |
DECIMAL(10,3) NOT NULL |
Fall Off Amount
|
| 36 |
BILL_DATE |
Date(10) |
DATE |
Fall Off Credit Date
|
| 37 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table:
%EDITTABLE4
|
| 38 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
Prompt Table:
FO_VNDR_LOC_VW
|
| 39 |
TTH_CONV_TMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Temp To Hire: Temporary Plcmnt
|
| 40 |
TTH_CONV_CAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Temp To Hire: Career Placement
|
| 41 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 42 |
BUSINESS_UNIT_HR |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit HR
Prompt Table:
BUS_UNIT_TBL_HR
|
| 43 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
FO_DEPTID_VW
Set Control Field: BUSINESS_UNIT
|
| 44 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
Prompt Table:
JOBCODE_TBL
|
| 45 |
PAYGROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Group
Prompt Table:
FO_PAYGROUP_VW2
Set Control Field: BUSINESS_UNIT
|
| 46 |
GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Pay Group
Prompt Table:
GP_PYGRP
Set Control Field: BUSINESS_UNIT
|
| 47 |
TASKGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Taskgroup
Prompt Table:
TL_TASKGRP_TBL
|
| 48 |
WORKGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Workgroup
Prompt Table:
TL_WRKGRP_TBL
|
| 49 |
TAX_LOCATION_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Tax Location Code
Prompt Table:
%EDITTABLE2
|
| 50 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
LOCATION_TBL
|
| 51 |
ASSIGN_JOB_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Force Additional Job Creation
A=Create Additional Job
C=Change Primary Job
U=Use Primary Job
Y/N Table Edit
|
| 52 |
PO_REF |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the purchase order number associated with a receivables item.
|
| 53 |
AWAITING_PO_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Awaiting PO
Y/N Table Edit
|
| 54 |
PRE_APPROVAL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Pre Approval Flag
Y/N Table Edit
|
| 55 |
CA_ALLOC_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Amount
1=Percent
2=Amount
Default Value: 1
|
| 56 |
MSG_PENDING |
Character(1) |
VARCHAR2(1) NOT NULL |
Message Pending Confirmation
Default Value: N
|
| 57 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract
|
| 58 |
SHIP_FROM_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship From Location
Prompt Table:
LOCATION_TBL
|
| 59 |
TAX_EXEMPT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Exemption License Exists
Y/N Table Edit
|
| 60 |
TAX_EXEMPT_CERT |
Character(30) |
VARCHAR2(30) NOT NULL |
Exemption Certificate
|
| 61 |
TAX_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Tax Code
Prompt Table:
CA_TAX_CD_VW
|
| 62 |
TAX_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Tax Group
Prompt Table:
PRODGP_NGTAX_VW
|
| 63 |
TAX_TRANS_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Type
1=Sale
2=Rental
3=Service
4=Purchase
5=Lease
B=Return
|
| 64 |
TAX_TRANS_SUB_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Sub Type
1=Property
2=Freight
3=Service
4=Rental or Lease
5=Expense
6=Misc
N=None
|
| 65 |
PHYSICAL_NATURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods
S=Services
|
| 66 |
PRODUCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product ID
Prompt Table:
%EDITTABLE3
|
| 67 |
MANAGER_CONTACT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Order Contact
Prompt Table:
FO_CUST_CONT_VW
|
| 68 |
INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice
|
| 69 |
CANDIDATE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Candidate Type
A=Applicant
E=Employee
|
| 70 |
REPLACED_BY |
Character(15) |
VARCHAR2(15) NOT NULL |
Replaced By
|
| 71 |
ORIGINAL_ASGN_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Work Assignment ID
|
| 72 |
REPLACEMENT_STS |
Character(1) |
VARCHAR2(1) NOT NULL |
Replacement Status
P=Pending Replacement
R=Replaced
|
| 73 |
REPLAC_REQUEST_DT |
Date(10) |
DATE |
Request Date
|
| 74 |
REPLAC_START_DT |
Date(10) |
DATE |
Request Date
|
| 75 |
TIME_START |
Time(15) |
TIMESTAMP |
Start Time
|
| 76 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 77 |
ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset Identification
|
| 78 |
RSRC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Work Order Management Resource Types
1=Labor
2=Tools
3=Material
Default Value: 1
|
| 79 |
RES_LN_NBR |
Number(5,0) |
INTEGER NOT NULL |
Resource Line No.
|
| 80 |
REQUIREMENT_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Project Team - Requirement ID
|
| 81 |
PROJ_ROLE |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Role
Prompt Table:
RS_PROJROLE_VW
|
| 82 |
ADDRESS_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number
Prompt Table:
%EDITTABLE7
|
| 83 |
TASK_TYPE |
Character(18) |
VARCHAR2(18) NOT NULL |
Task Category
Default Value: BE
Prompt Table:
RS_ASSGN_TTVW
|
| 84 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 85 |
ASSIGNED_TO |
Character(30) |
VARCHAR2(30) NOT NULL |
Assigned To
Prompt Table:
RS_OPR_NAME_VW1
|
| 86 |
RESERVED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Reserved Flag
B=Both
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 87 |
DESCR254_MIXED |
Character(254) |
VARCHAR2(254) NOT NULL |
Description
|
| 88 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|
| 89 |
CNTCT_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Contact Sequence Number
Prompt Table:
CUST_CONTACT
|
| 90 |
STATUS_APPR_ONCE |
Character(1) |
VARCHAR2(1) NOT NULL |
First submit status change
Y/N Table Edit
Default Value: N
|
| 91 |
STATUS_APPR_SECOND |
Character(1) |
VARCHAR2(1) NOT NULL |
First submit status change
Y/N Table Edit
|
| 92 |
DATECHG_APPR_ONCE |
Character(1) |
VARCHAR2(1) NOT NULL |
First submit date change
Y/N Table Edit
Default Value: N
|
| 93 |
DTCHG_APPR_SECOND |
Character(1) |
VARCHAR2(1) NOT NULL |
First submit date change
Y/N Table Edit
|
| 94 |
BUSINESS_UNIT_AM |
Character(5) |
VARCHAR2(5) NOT NULL |
AM Business Unit
|
| 95 |
SHOP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Shop Identification
|
| 96 |
CRAFT_ID |
Character(16) |
VARCHAR2(16) NOT NULL |
Craft Identification
|
| 97 |
BUSINESS_UNIT_WO |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit Work Order
|
| 98 |
WO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Work Order Identification
|
| 99 |
WO_TASK_ID |
Number(5,0) |
INTEGER NOT NULL |
Task Number
|
| 100 |
RES_CALENDAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Resource calendar field.
P=Project Calendar
R=Resource Calendar
Default Value: R
|
| 101 |
SKIP_INELGBL_DAYS |
Character(1) |
VARCHAR2(1) NOT NULL |
Skip Ineligible Days
Y/N Table Edit
Default Value: INSTALLATION_RS.SKIP_INELGBL_DAYS
|
| 102 |
PROCESSED_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Processed Code
E=Processed with Error
I=In Process
N=Not Processed
Y=Processed
Default Value: Y
|
| 103 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|