| # |
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
Default Value: SSFPS_RUN_CNTRC.CONTRACT_NUM
Prompt Table:
TP_CONTRACT_VW4
|
| 3 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PEOPLE_SRCH
|
| 4 |
TP_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Contract Status
A=Active
C=Cancelled
H=Hold
I=Inactive
U=Not Posted
Default Value: A
|
| 5 |
REF1_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Reference Nbr
|
| 6 |
TP_CON_NUM_PAYMENT |
Number(3,0) |
SMALLINT NOT NULL |
Number Of Payments
Default Value: TP_CONTRACT.TP_CON_NUM_PAYMENT
|
| 7 |
TP_CAP_STUDENT |
Number(15,2) |
DECIMAL(14,2) NOT NULL |
Third Party Student Maximum
|
| 8 |
TP_MAX_AMOUNT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Maximum Amount
|
| 9 |
COURSE_LIST |
Character(9) |
VARCHAR2(9) NOT NULL |
Course List
Prompt Table:
CRSE_LST_HDR_SF
Set Control Field: BUSINESS_UNIT
|
| 10 |
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
Default Value: TP_CONTRACT.TP_CON_TYPE
|
| 11 |
SF_PRIORITY |
Number(6,0) |
INTEGER NOT NULL |
Contract Priority
Default Value: TP_CONTRACT.SF_PRIORITY
|
| 12 |
PLAN_TYPE_SF |
Character(1) |
VARCHAR2(1) NOT NULL |
Plan Type
1=Existing Charges Only
2=Lump Sum
3=Calculated
Default Value: TP_CONTRACT.PLAN_TYPE_SF
|
| 13 |
SSF_TPSTD_USERDEF1 |
Character(50) |
VARCHAR2(50) NOT NULL |
Third Party Student User Defined Field 1.
|
| 14 |
SSF_TPSTD_USERDEF2 |
Character(50) |
VARCHAR2(50) NOT NULL |
Third Party Student User Defined Field 2.
|
| 15 |
SSF_TPSTD_USERDEF3 |
Character(50) |
VARCHAR2(50) NOT NULL |
Third Party Student User Defined Field 3.
|
| 16 |
SSF_TPSTD_USERDEF4 |
Character(50) |
VARCHAR2(50) NOT NULL |
Third Party Student User Defined Field 4.
|
| 17 |
SSF_TPSTD_USERDEF5 |
Character(50) |
VARCHAR2(50) NOT NULL |
Third Party Student User Defined Field 5.
|