| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT
Prompt Table:
SP_BU_SF_NONVW
|
| 2 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract Number
|
| 3 |
EXT_ORG_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
External Org ID
Prompt Table:
EXT_ORG_TBL
|
| 4 |
ORG_CODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Organization Code
|
| 5 |
ORG_CONTACT |
Number(4,0) |
SMALLINT NOT NULL |
Contact Nbr
Prompt Table:
ORG_CONTACT2_VW
|
| 6 |
START_DT |
Date(10) |
DATE |
Start Date
|
| 7 |
END_DT |
Date(10) |
DATE |
end date
|
| 8 |
ACAD_YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Academic Year
|
| 9 |
STRM |
Character(4) |
VARCHAR2(4) NOT NULL |
Term
Prompt Table:
TERM_VAL_TBL
|
| 10 |
TP_CAP_CONTRACT |
Number(15,2) |
DECIMAL(14,2) NOT NULL |
Contract Max
|
| 11 |
TP_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Contract Status
A=Active
C=Cancelled
H=Hold
I=Inactive
U=Not Posted
Default Value: A
|
| 12 |
ITEM_TYPE |
Character(12) |
VARCHAR2(12) NOT NULL |
Item Type
Prompt Table:
SP_ITEMCH_NONVW
Set Control Field: INSTITUTION
|
| 13 |
TP_DISC_ITEM_TYPE |
Character(12) |
VARCHAR2(12) NOT NULL |
Item Type for the corporate discount
Prompt Table:
SP_ITACC_NONVW
Set Control Field: INSTITUTION
|
| 14 |
PMT_ITEM_TYPE |
Character(12) |
VARCHAR2(12) NOT NULL |
Payment Item Type
Prompt Table:
%EDITTABLE
|
| 15 |
ACCOUNT_TYPE_SF |
Character(3) |
VARCHAR2(3) NOT NULL |
Account Type
Prompt Table:
ACCT_TYP_PMT_VW
|
| 16 |
TP_CAP_STUDENT |
Number(15,2) |
DECIMAL(14,2) NOT NULL |
Third Party Student Maximum
|
| 17 |
TP_CONTRACT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Third Party Contract Type
C=Specific Course
L=Specific Course List
P=Specific Year or Period
T=Specific Term
Default Value: P
|
| 18 |
TP_CON_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Third Party Contract Type
C=Collection Agreement
D=Deferral Contract
M=Multi-year Payment Plan
P=Payment Plan
R=Pre-Payment Plan
T=Third Party
|
| 19 |
TP_CON_DATE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Contract Date Types
A=Academic Year
L=Course List
R=Date Range
T=Term
Default Value: R
|
| 20 |
TP_CON_LAST_COR_DT |
Date(10) |
DATE |
Last Date to Enter Corrections
|
| 21 |
TP_CON_BILL_DT |
Date(10) |
DATE |
First Billing Date
Default Value: %date
|
| 22 |
TP_DUE_DATE_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
This field is used to calculate the due date using the billing date and adding this field
|
| 23 |
TP_CON_NUM_PAYMENT |
Number(3,0) |
SMALLINT NOT NULL |
Number Of Payments
|
| 24 |
TP_CON_ACCT_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Administrative Account Type
Prompt Table:
ACCT_TYP_TBL_SF
|
| 25 |
TP_CON_PRI_AID_YR |
Number(4,0) |
SMALLINT NOT NULL |
Prior Aid Year
Prompt Table:
AID_YEAR_TBL
|
| 26 |
TP_CON_CURR_AID_YR |
Number(4,0) |
SMALLINT NOT NULL |
Current Aid Year
Prompt Table:
AID_YEAR_TBL
|
| 27 |
TP_CON_BILL_ITMTPY |
Character(12) |
VARCHAR2(12) NOT NULL |
Billing Item Type
Prompt Table:
SP_ITEMBI_NONVW
Set Control Field: INSTITUTION
|
| 28 |
TP_CON_BILL_CYCLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Billing Cycle
B=Bi-Monthly
M=Monthly
O=One Time
U=User Selected
W=Weekly
|
| 29 |
TP_CON_EXT_CON_NUM |
Character(30) |
VARCHAR2(30) NOT NULL |
External Contract
|
| 30 |
TP_CON_PLAN_FEE |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Plan Fee Amount
|
| 31 |
EXTRA_PAY_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Extra Payments Option
1=First Bill
A=All Bills
L=Last Bill
|
| 32 |
TP_ADJ_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjustment Option
1=Adjust First Bill
E=Adjust Equally
L=Adjust Last Bill
N=Do Not Adjust
Default Value: N
|
| 33 |
ITEM_TYPE_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Item Type Group
Prompt Table:
ITEM_GROUP_TBL
|
| 34 |
TP_CON_PAY_CHARGE |
Character(12) |
VARCHAR2(12) NOT NULL |
Payment Charge
Prompt Table:
SP_ITYPCH_NONVW
|
| 35 |
TP_CON_PAY_CREDIT |
Character(12) |
VARCHAR2(12) NOT NULL |
Payment Credit
Prompt Table:
SP_ITYPPY_NONVW
|
| 36 |
TP_CON_PAY_CRE_TYP |
Character(3) |
VARCHAR2(3) NOT NULL |
Credit Account Type
Prompt Table:
ACCT_TYP_TBL_SF
|
| 37 |
COLLECTION_ID |
Number(12,0) |
DECIMAL(12) NOT NULL |
Collection ID
|
| 38 |
PAY_PLAN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Plan Type
B=Create Billing Entries
C=Credit Original Account
|
| 39 |
TP_ASSESS_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
This field will be used by the institution to determine the type of charge for payment plans.
1=Payment Plan Fee
2=Percentage of Payment Plan
3=Monthly Interest Rate
|
| 40 |
TP_ASSESS_MNTH_INT |
Number(10,6) |
DECIMAL(9,6) NOT NULL |
This field will be used by the institution to assess monthly interest for payment plans.
|
| 41 |
TP_ASSESS_FLAT_PER |
Number(10,6) |
DECIMAL(9,6) NOT NULL |
This field will be used by the institution to charge a flat percentage assessment interest rate for payment plans.
|
| 42 |
TP_ASSESS_AMT |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
This field will be used by the institution to charge fees for payment plans.
The field will contain the dollar amount of the flat fee charged.
|
| 43 |
TP_ASSESS_FEE_SPLT |
Character(1) |
VARCHAR2(1) NOT NULL |
This field will be used by the institution to split assessment fees for payment plans.
1=Add to first payment
2=Add to last payment
3=Split over all payments
|
| 44 |
TP_ASSESS_ITEM_TYP |
Character(12) |
VARCHAR2(12) NOT NULL |
This field will be used by the institution to charge fees for payment plans.
The field will contain the item type that will be used to track the assessment interest/fees.
Prompt Table:
SP_ITEMCH_NONVW
Set Control Field: INSTITUTION
|
| 45 |
TREE_NAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Tree Name
Default Value: BUS_UNIT_TBL_SF.TREE_NAME2
Prompt Table:
TREE_SF_VW
|
| 46 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 47 |
DESCR1 |
Character(30) |
VARCHAR2(30) NOT NULL |
Descr
|
| 48 |
CLASS_NBR |
Number(5,0) |
INTEGER NOT NULL |
Class Nbr
Prompt Table:
CLASS_TBL_VW
|
| 49 |
DELIVER_CODE |
Character(30) |
VARCHAR2(30) NOT NULL |
Delivery Code
|
| 50 |
REQUISITION_NBR |
Character(30) |
VARCHAR2(30) NOT NULL |
Requisition Number
|
| 51 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: BUS_UNIT_TBL_SF.BASE_CURRENCY
Prompt Table:
CURRENCY_CD_TBL
|
| 52 |
DEFER_DAYS_CHRG |
Number(3,0) |
SMALLINT NOT NULL |
Defer Days Charges
|
| 53 |
DEFER_DAYS_ADJ |
Number(3,0) |
SMALLINT NOT NULL |
Defer Days Adjustments
|
| 54 |
DEFER_DT_CHRG |
Date(10) |
DATE |
Defer Date Charges
|
| 55 |
DEFER_DT_ADJ |
Date(10) |
DATE |
Defer Date Adjustments
|
| 56 |
LAST_DT_DEF_CHRG |
Date(10) |
DATE |
Last Date to Defer Charges
|
| 57 |
LAST_DT_DEF_ADJ |
Date(10) |
DATE |
Last Date to Defer Adjustments
|
| 58 |
TOT_DEFER_AMT |
Number(15,2) |
DECIMAL(14,2) NOT NULL |
Total Amount to Defer
|
| 59 |
DUE_DT |
Date(10) |
DATE |
Due Date
|
| 60 |
USE_DUE_DATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Date
D=Due Days
T=Due Date
|
| 61 |
USE_DUE_DATE2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Date
D=Due Days
T=Due Date
|
| 62 |
USE_DUE_DATE3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Date
D=Due Days
T=Due Date
|
| 63 |
DEFICIT_AMT |
Number(15,2) |
DECIMAL(14,2) NOT NULL |
Deficit Amount
|
| 64 |
DEFICIT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Deficit Flag
Y/N Table Edit
Default Value: N
|
| 65 |
GEN_TRANSFER_ITEM |
Character(1) |
VARCHAR2(1) NOT NULL |
Generate Transfer Item
Y/N Table Edit
|
| 66 |
TRANSFER_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Number to Transfer
|
| 67 |
TRANSFER_ITEM_TYPE |
Character(12) |
VARCHAR2(12) NOT NULL |
Transfer Item Type
Prompt Table:
%EDITTABLE2
|
| 68 |
CREDIT_ITEM_TYPE |
Character(12) |
VARCHAR2(12) NOT NULL |
Credit Item Type
Prompt Table:
SP_ITYPPT_NONVW
|
| 69 |
INTEREST_CALC_MTHD |
Character(1) |
VARCHAR2(1) NOT NULL |
Interest Calculation Method
M=Calculated Monthly
Y=Calculated Yearly
|
| 70 |
INTEREST_RATE |
Number(16,6) |
DECIMAL(15,6) NOT NULL |
Interest Rate
|
| 71 |
INTEREST_ITEM_TYPE |
Character(12) |
VARCHAR2(12) NOT NULL |
Interest Item Type
Prompt Table:
SP_ITYPPC_NONVW
|
| 72 |
MONTHCD |
Character(2) |
VARCHAR2(2) NOT NULL |
Month
01=01 - January
02=02 - February
03=03 - March
04=04 - April
05=05 - May
06=06 - June
07=07 - July
08=08 - August
09=09 - September
10=10 - October
11=11 - November
12=12 - December
|
| 73 |
DAY_OF_MONTH |
Number(2,0) |
SMALLINT NOT NULL |
Day of the Month
|
| 74 |
ITEM_TYPE_GRP_OFF |
Character(10) |
VARCHAR2(10) NOT NULL |
Offset Item Type Group
Prompt Table:
ITEM_GROUP_TBL
|
| 75 |
MAX_TERM_AMT |
Number(15,2) |
DECIMAL(14,2) NOT NULL |
Max Term Amount
|
| 76 |
TP_EXT_CONTRACT |
Character(30) |
VARCHAR2(30) NOT NULL |
External Contract Number
|
| 77 |
MAX_AMT |
Signed Number(14,5) |
DECIMAL(12,5) NOT NULL |
Maximum Amount
|
| 78 |
TERM_FROM |
Character(4) |
VARCHAR2(4) NOT NULL |
Term From
Prompt Table:
TERM_VAL_TBL
|
| 79 |
TERM_TO |
Character(4) |
VARCHAR2(4) NOT NULL |
Term To
Prompt Table:
TERM_VAL_TBL
|
| 80 |
TERM_FROM_OFF |
Character(4) |
VARCHAR2(4) NOT NULL |
Offset Term From
Prompt Table:
TERM_VAL_TBL
|
| 81 |
TERM_TO_OFF |
Character(4) |
VARCHAR2(4) NOT NULL |
Offset Term To
Prompt Table:
TERM_VAL_TBL
|
| 82 |
ADD_CHRGS_DT |
Date(10) |
DATE |
Charge Add Date
|
| 83 |
ADJ_CHRGS_DT |
Date(10) |
DATE |
Charge Adjust Date
|
| 84 |
ADD_OFF_DT |
Date(10) |
DATE |
Offset Add Chrg Date
|
| 85 |
ADJ_OFF_DT |
Date(10) |
DATE |
Offset Adjust Chrg Date
|
| 86 |
ANTIC_AID_TRM_FROM |
Character(4) |
VARCHAR2(4) NOT NULL |
Antic Aid Term From
Prompt Table:
TERM_VAL_TBL
|
| 87 |
ANTIC_AID_TERM_TO |
Character(4) |
VARCHAR2(4) NOT NULL |
Antic Aid Term To
Prompt Table:
TERM_VAL_TBL
|
| 88 |
ANTIC_AID_DT |
Date(10) |
DATE |
Antic Aid DT
|
| 89 |
CALC_REAL_TIME_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Calc. Real Time Flag
Y/N Table Edit
Default Value: N
|
| 90 |
LUMP_SUM_AMT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Lump Sum Amt
|
| 91 |
PLAN_TYPE_SF |
Character(1) |
VARCHAR2(1) NOT NULL |
Plan Type
1=Existing Charges Only
2=Lump Sum
3=Calculated
Default Value: 1
|
| 92 |
GUESS_AMT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Guess Amt
|
| 93 |
GUESS_AMT_EXPIR_DT |
Date(10) |
DATE |
Guess Amt Exp. DT
|
| 94 |
TP_MAX_AMOUNT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Maximum Amount
|
| 95 |
GUST_AMT_ITEM_TYPE |
Character(12) |
VARCHAR2(12) NOT NULL |
Guess Amount Item type
Prompt Table:
SP_ITYPPY_NONVW
|
| 96 |
SF_PRIORITY |
Number(6,0) |
INTEGER NOT NULL |
Contract Priority
Default Value: 999999
|
| 97 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
Default Value: TP_CONTRACT.DESCR
|
| 98 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|
| 99 |
COURSE_LIST |
Character(9) |
VARCHAR2(9) NOT NULL |
Course List
Prompt Table:
CRSE_LST_HDR_SF
Set Control Field: BUSINESS_UNIT
|
| 100 |
PLAN_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.
|
| 101 |
DEDCD |
Character(6) |
VARCHAR2(6) NOT NULL |
Deduction Code
Prompt Table:
SSF_DED_TBL_VW
|
| 102 |
SERVICE_IMPACT |
Character(5) |
VARCHAR2(5) NOT NULL |
Service Impact
Prompt Table:
SSF_SVCIMP_D_VW
|
| 103 |
ORG_CONTACT_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Contact Type
Prompt Table:
ORG_CNT_TYP_TBL
|
| 104 |
SSF_SELF_SERVICE |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Self Service Enrollment
Y/N Table Edit
Default Value: N
|
| 105 |
STDNT_GROUP |
Character(4) |
VARCHAR2(4) NOT NULL |
Student Group
Prompt Table:
STDNT_GROUP_TBL
|
| 106 |
MINIMUM_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Mininum Transaction Amount
|
| 107 |
SSF_SS_START_DATE |
Date(10) |
DATE |
Self Service Start Date
|
| 108 |
SSF_SS_END_DATE |
Date(10) |
DATE |
Self Service End Date
|
| 109 |
SSF_ALLOW_AMOUNT |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Change in Amount
Y/N Table Edit
Default Value: N
|
| 110 |
SSF_ALLOW_INSTALL |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Change in number of installments
Y/N Table Edit
Default Value: N
|
| 111 |
SSF_LIMIT_AMT |
Character(1) |
VARCHAR2(1) NOT NULL |
Limit Plan to Existing Charges
Y/N Table Edit
Default Value: N
|
| 112 |
SSF_TPCON_USERDEF1 |
Character(50) |
VARCHAR2(50) NOT NULL |
Third Party Contract User Defined Field 1.
|
| 113 |
SSF_TPCON_USERDEF2 |
Character(50) |
VARCHAR2(50) NOT NULL |
Third Party Contract User Defined Field 2.
|
| 114 |
SSF_TPCON_USERDEF3 |
Character(50) |
VARCHAR2(50) NOT NULL |
Third Party Contract User Defined Field 3.
|
| 115 |
SSF_TPCON_USERDEF4 |
Character(50) |
VARCHAR2(50) NOT NULL |
Third Party Contract User Defined Field 4.
|
| 116 |
SSF_TPCON_USERDEF5 |
Character(50) |
VARCHAR2(50) NOT NULL |
Third Party Contract User Defined Field 5.
|
| 117 |
SSF_REF_STDNT_CHRG |
Character(1) |
VARCHAR2(1) NOT NULL |
Cross Reference Student Charge
Y/N Table Edit
Default Value: N
|
| 118 |
SSF_TRACK_DUE_CHRG |
Character(1) |
VARCHAR2(1) NOT NULL |
Track Charges by Due Date
Y/N Table Edit
Default Value: N
|
| 119 |
SSF_RECON_DUE_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
Reconcile Org Due Date
Y/N Table Edit
Default Value: N
|
| 120 |
SSF_ENFORCE_TPMAX |
Character(1) |
VARCHAR2(1) NOT NULL |
Enforce Contract Max
Y/N Table Edit
Default Value: Y
|
| 121 |
SSF_TPC_BILL_ENRL |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicate enrollment detail required on TPC Billing extracts
Y/N Table Edit
Default Value: N
|
| 122 |
INVOICE_FORM_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Invoice Layout ID
Prompt Table:
BI_IVC_LAYOUTVW
|
| 123 |
SCC_ROW_ADD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Created By
|
| 124 |
SCC_ROW_ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Created
|
| 125 |
SCC_ROW_UPD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Updated By
|
| 126 |
SCC_ROW_UPD_DTTM |
DateTime(26) |
TIMESTAMP |
Last Update Date/Time
|
| 127 |
SSF_DESCR_LONG |
Long Character |
CLOB |
Description
|