| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
Default Value: OPR_DEF_TBL_RB.SETID
Prompt Table:
SP_SETID_NONVW
|
| 2 |
AGREEMENT_CODE |
Character(30) |
VARCHAR2(30) NOT NULL |
This field represents the agreement code (name) for an agreement
|
| 3 |
AGR_RENEWAL_NUM |
Number(4,0) |
SMALLINT NOT NULL |
This field represents the agreement renewal number (agreements begin at a value of one and the number is incremented with every renewal)
|
| 4 |
AGREEMENT_LINE |
Character(10) |
VARCHAR2(10) NOT NULL |
This field records the value for the agreement line number
Default Value: 001
|
| 5 |
START_DT |
Date(10) |
DATE NOT NULL |
Start date field to store start date value.
Default Value: %Date
|
| 6 |
END_DT |
Date(10) |
DATE |
This field stores the end date values.
|
| 7 |
AGRT_LN_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Field for Storing the Agreement Line Status
001=1-Pending
005=2-Active
009=3-Closed
Default Value: 001
|
| 8 |
SERVICE_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Service ID
Prompt Table:
RF_AG_SVC_VW
|
| 9 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 10 |
PRODUCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product ID
Prompt Table:
%EDITTABLE
|
| 11 |
AG_LINE_PRICE |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Agreement Line Price (refers to base price)
|
| 12 |
AGR_UNIT_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
This field represents the agreement price unit type
CASE=Case
DAY=Day
HOUR=Hour
ITEM=Item
MON=Month
SO=Service Order
WEEK=Week
YEAR=Year
|
| 13 |
PURCHASE_OPTN |
Character(4) |
VARCHAR2(4) NOT NULL |
This field is used to represent the purchase option (used in agreement pricing)
FLAT=Flat Rate
PRPD=Prepaid Cases/Services
TM=Time & Material
Prompt Table:
RF_AG_PURCH_VW
|
| 14 |
AG_LINE_MOD_PRICE |
Number(17,5) |
DECIMAL(16,5) NOT NULL |
Final Agreement Line Price (price including uplifts and discounts, etc.)
|
| 15 |
PREPAID_QTY |
Number(6,0) |
INTEGER NOT NULL |
This field is used to store the Prepaid Quantity.
Prompt Table:
%EDITTABLE2
|
| 16 |
AG_SVC_LINE_PRICE |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Transaction price for service on an agreement line
|
| 17 |
SVC_UNIT_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
This field is used to represent the transaction price unit type
CASE=Case
DAY=Day
HOUR=Hour
MON=Month
SO=Service Order
WEEK=Week
YEAR=Year
|
| 18 |
SVC_PURCH_OPT |
Character(4) |
VARCHAR2(4) NOT NULL |
This field is used to represent the transaction price purchase option
FLAT=Flat Rate
PRPD=Prepaid Services/Cases
TM=Time & Materials
|
| 19 |
SERVICE_CTR |
Signed Number(10,2) |
DECIMAL(8,2) NOT NULL |
This field is used to represent the remaining quantity available for pre-paid services
|
| 20 |
PRPD_UNIT_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
This field is used to represent the prepaid unit type
CASE=Case
DAY=Day
HOUR=Hour
MON=Month
SO=Service Order
WEEK=Week
YEAR=Year
|
| 21 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
This field stores the Currency Code value.
|
| 22 |
RATE_AMOUNT |
Number(11,4) |
DECIMAL(10,4) NOT NULL |
Rate Amount
|
| 23 |
AGR_MONTHLY_PRICE |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
This field represents the monthly price for an agreement or agreement line
|
| 24 |
AGR_MONTH_DUR |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
This field represents the duration of an agreement expressed in months
|
| 25 |
PERCENTAGE |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Percentage
|
| 26 |
ENTITLE_PCT |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
This field represents the entitlement uplift or discount percent
|
| 27 |
QUANTITY_USED |
Number(10,0) |
DECIMAL(10) NOT NULL |
Used to store the product quantity on an installed product.
|
| 28 |
INST_PROD_QTY |
Number(10,0) |
DECIMAL(10) NOT NULL |
The quantity of an installed product that is serviced under an agreement.
|
| 29 |
PO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Purchase Order
|
| 30 |
SCHEDULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Schedule for integration with Contracts.
Prompt Table:
RF_SCHED_TBL_VW
|
| 31 |
PYMNT_TERMS_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
Prompt Table:
PAY_TRMS_VW
|
| 32 |
ADJ_AMT |
Signed Number(22,5) |
DECIMAL(20,5) NOT NULL |
Adjustment Amount field used on the work record RF_SO_BLDET_WRK.
|
| 33 |
ADJ_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Adjustment Percentage Value for the Agreement Line
|
| 34 |
REASON_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Used to store the identification number for the reason code.
Prompt Table:
RF_AG_REASON_VW
|
| 35 |
ADJUST_REASON |
Character(254) |
VARCHAR2(254) NOT NULL |
Adhoc Reason for the Adjustment, Uplift or Discount.
|
| 36 |
NO_OF_TIME_UNIT |
Number(9,2) |
DECIMAL(8,2) NOT NULL |
Number of Time Units used in the Agreement Line
|
| 37 |
BASE_PRICE |
Signed Number(18,5) |
DECIMAL(16,5) NOT NULL |
Base Price Field used in Agreement Line Record to store the Base Price of the Agreement Line
|
| 38 |
SUBTOTAL |
Signed Number(18,5) |
DECIMAL(16,5) NOT NULL |
Subtotal field for Agreement Line. For display purpose and not for storing.
|
| 39 |
ROLETYPE_EMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag value to determine if the worker has Employee Role Type.
|
| 40 |
ROLETYPE_CW |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag value to determine if the worker has Contingent Worker Role Type.
|
| 41 |
ROLETYPE_POI |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag value to determine if the person has POI role type.
|
| 42 |
HR_STAT_ACTIVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag for Active Worker Status.
|
| 43 |
HR_STAT_INACTIVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag for Inactive Worker Status.
|
| 44 |
HOLIDAY_SCHEDULE |
Character(6) |
VARCHAR2(6) NOT NULL |
This is the holiday schedule field.
Prompt Table:
HOLIDAY_TBL
|
| 45 |
SO_PREPAID_QTY |
Number(6,0) |
INTEGER NOT NULL |
Prepaid quantity for service on agreement line setup.
|
| 46 |
SO_PREPAID_UNIT |
Character(4) |
VARCHAR2(4) NOT NULL |
Prepaid Unit. The field is used to store prepaid unit options on agreement line for service - agreement of category External - No Pricing.
HOUR=Hour
SO=Service Order
|
| 47 |
SO_REMAINING_QTY |
Signed Number(10,2) |
DECIMAL(8,2) NOT NULL |
Service Order Remaining Quantity used in agreement line setup.
|
| 48 |
ROW_ADDED_DTTM |
DateTime(26) |
TIMESTAMP |
This is a datetime field for record creation.
|
| 49 |
ROW_ADDED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who added the row.
|
| 50 |
ROW_LASTMANT_DTTM |
DateTime(26) |
TIMESTAMP |
The date and time that the row was last updated.
|
| 51 |
ROW_LASTMANT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who last modified the row.
|
| 52 |
SYNCID |
Number(10,0) |
DECIMAL(10) NOT NULL |
The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
|
| 53 |
SYNCDTTM |
DateTime(26) |
TIMESTAMP |
Synchronization Last Update Date Time
|