| # |
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 |
TP_SEQ_NBR |
Number(7,0) |
INTEGER NOT NULL |
TP Sequence Number
|
| 4 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PEOPLE_SRCH
|
| 5 |
TP_CAP_STUDENT |
Number(15,2) |
DECIMAL(14,2) NOT NULL |
Third Party Student Maximum
Default Value: TP_CONTRACT.TP_CAP_STUDENT
|
| 6 |
TP_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Contract Status
A=Active
C=Cancelled
H=Hold
I=Inactive
U=Not Posted
Default Value: A
|
| 7 |
PROJ_TUIT_AMT |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Projected Tuition Amount
|
| 8 |
PRE_PLAN_AMT |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Pre-Payment Plan Amount
|
| 9 |
PRE_OVERRIDE_AMT |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Override Tuition Amount
|
| 10 |
PRE_EST_FA_AMT |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Estimated Financial Aid
|
| 11 |
TP_CON_BILL_DT |
Date(10) |
DATE |
First Billing Date
|
| 12 |
TP_CON_NUM_PAYMENT |
Number(3,0) |
SMALLINT NOT NULL |
Number Of Payments
|
| 13 |
EXTRA_PAY_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Extra Payments Option
1=First Bill
A=All Bills
L=Last Bill
|
| 14 |
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: TP_CONTRACT.TP_ADJ_OPTION
|
| 15 |
TP_POST_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Pre Payment Post Status
Y/N Table Edit
Default Value: N
|
| 16 |
TP_ASSESS_WAIV_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
This field will be used by the institution to waive assessment fees for payment plans on a student by student basis.
Y/N Table Edit
Default Value: N
|
| 17 |
ITEM_NBR_PAYMENT |
Character(15) |
VARCHAR2(15) NOT NULL |
Item Nbr Payment
|
| 18 |
PAYMENT_ID_NBR |
Number(12,0) |
DECIMAL(12) NOT NULL |
Payment ID Nbr
|
| 19 |
TOT_DEFER_AMT |
Number(15,2) |
DECIMAL(14,2) NOT NULL |
Total Amount to Defer
Default Value: TP_CONTRACT.TOT_DEFER_AMT
|
| 20 |
LAST_DT_DEF_CHRG |
Date(10) |
DATE |
Last Date to Defer Charges
Default Value: TP_CONTRACT.LAST_DT_DEF_CHRG
|
| 21 |
LAST_DT_DEF_ADJ |
Date(10) |
DATE |
Last Date to Defer Adjustments
Default Value: TP_CONTRACT.LAST_DT_DEF_ADJ
|
| 22 |
DEFICIT_AMT |
Number(15,2) |
DECIMAL(14,2) NOT NULL |
Deficit Amount
Default Value: TP_CONTRACT.DEFICIT_AMT
|
| 23 |
DEFICIT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Deficit Flag
Y/N Table Edit
Default Value: TP_CONTRACT.DEFICIT_FLG
|
| 24 |
GEN_TRANSFER_ITEM |
Character(1) |
VARCHAR2(1) NOT NULL |
Generate Transfer Item
Y/N Table Edit
Default Value: TP_CONTRACT.GEN_TRANSFER_ITEM
|
| 25 |
TP_CON_PAY_CREDIT |
Character(12) |
VARCHAR2(12) NOT NULL |
Payment Credit
Default Value: TP_CONTRACT.TP_CON_PAY_CREDIT
Prompt Table:
SP_ITYPPY_NONVW
|
| 26 |
TRANSFER_ITEM_TYPE |
Character(12) |
VARCHAR2(12) NOT NULL |
Transfer Item Type
Default Value: TP_CONTRACT.TRANSFER_ITEM_TYPE
Prompt Table:
SP_ITYPTR_NONVW
|
| 27 |
TRANSFER_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Number to Transfer
Default Value: TP_CONTRACT.TRANSFER_NBR
|
| 28 |
SPONSOR_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Sponsor EmplID
Prompt Table:
PEOPLE_SRCH
|
| 29 |
REFUND_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Refund ID
Prompt Table:
PEOPLE_SRCH
|
| 30 |
BACKDATE_DT |
Date(10) |
DATE |
Back Date
|
| 31 |
MAX_AMT |
Signed Number(14,5) |
DECIMAL(12,5) NOT NULL |
Maximum Amount
|
| 32 |
ITEM_TYPE_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Item Type Group
Prompt Table:
ITEM_GROUP_TBL
|
| 33 |
ITEM_TYPE_GRP_OFF |
Character(10) |
VARCHAR2(10) NOT NULL |
Offset Item Type Group
Prompt Table:
ITEM_GROUP_TBL
|
| 34 |
TERM_FROM |
Character(4) |
VARCHAR2(4) NOT NULL |
Term From
Prompt Table:
TERM_VAL_TBL
|
| 35 |
TERM_TO |
Character(4) |
VARCHAR2(4) NOT NULL |
Term To
Prompt Table:
TERM_VAL_TBL
|
| 36 |
TERM_FROM_OFF |
Character(4) |
VARCHAR2(4) NOT NULL |
Offset Term From
Prompt Table:
TERM_VAL_TBL
|
| 37 |
TERM_TO_OFF |
Character(4) |
VARCHAR2(4) NOT NULL |
Offset Term To
Prompt Table:
TERM_VAL_TBL
|
| 38 |
ADD_CHRGS_DT |
Date(10) |
DATE |
Charge Add Date
|
| 39 |
ADJ_CHRGS_DT |
Date(10) |
DATE |
Charge Adjust Date
|
| 40 |
ADD_OFF_DT |
Date(10) |
DATE |
Offset Add Chrg Date
|
| 41 |
ADJ_OFF_DT |
Date(10) |
DATE |
Offset Adjust Chrg Date
|
| 42 |
ANTIC_AID_TRM_FROM |
Character(4) |
VARCHAR2(4) NOT NULL |
Antic Aid Term From
Prompt Table:
TERM_VAL_TBL
|
| 43 |
ANTIC_AID_TERM_TO |
Character(4) |
VARCHAR2(4) NOT NULL |
Antic Aid Term To
Prompt Table:
TERM_VAL_TBL
|
| 44 |
ANTIC_AID_DT |
Date(10) |
DATE |
Antic Aid DT
|
| 45 |
CALC_REAL_TIME_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Calc. Real Time Flag
Y/N Table Edit
|
| 46 |
LUMP_SUM_AMT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Lump Sum Amt
|
| 47 |
PLAN_TYPE_SF |
Character(1) |
VARCHAR2(1) NOT NULL |
Plan Type
1=Existing Charges Only
2=Lump Sum
3=Calculated
|
| 48 |
GUESS_AMT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Guess Amt
|
| 49 |
GUESS_AMT_EXPIR_DT |
Date(10) |
DATE |
Guess Amt Exp. DT
|
| 50 |
TP_MAX_AMOUNT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Maximum Amount
|
| 51 |
PMT_ID_NBR_GUSTYPE |
Number(12,0) |
DECIMAL(12) NOT NULL |
Payment ID Nbr
|
| 52 |
SF_PRIORITY |
Number(6,0) |
INTEGER NOT NULL |
Contract Priority
|
| 53 |
REF1_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Reference Nbr
|
| 54 |
COURSE_LIST |
Character(9) |
VARCHAR2(9) NOT NULL |
Course List
Prompt Table:
CRSE_LST_HDR_SF
Set Control Field: BUSINESS_UNIT
|
| 55 |
SSF_AGREEMENT_NBR |
Character(12) |
VARCHAR2(12) NOT NULL |
Agreement Number
|
| 56 |
SSF_TPSTD_USERDEF1 |
Character(50) |
VARCHAR2(50) NOT NULL |
Third Party Student User Defined Field 1.
|
| 57 |
SSF_TPSTD_USERDEF2 |
Character(50) |
VARCHAR2(50) NOT NULL |
Third Party Student User Defined Field 2.
|
| 58 |
SSF_TPSTD_USERDEF3 |
Character(50) |
VARCHAR2(50) NOT NULL |
Third Party Student User Defined Field 3.
|
| 59 |
SSF_TPSTD_USERDEF4 |
Character(50) |
VARCHAR2(50) NOT NULL |
Third Party Student User Defined Field 4.
|
| 60 |
SSF_TPSTD_USERDEF5 |
Character(50) |
VARCHAR2(50) NOT NULL |
Third Party Student User Defined Field 5.
|