| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_CS.SETID
Prompt Table:
SP_SETID_NONVW
|
| 2 |
INVOICE_FORM_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Invoice Layout ID
|
| 3 |
STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Status Indicator
A=Active
I=Inactive
Default Value: A
|
| 4 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 5 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
|
| 6 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
LOCATION_TBL
|
| 7 |
INCLUDE_AA_TOTAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Anticipated Aid Total
Y/N Table Edit
Default Value: N
|
| 8 |
AA_DETAIL |
Character(1) |
VARCHAR2(1) NOT NULL |
Anticipated Aid Detail
Y/N Table Edit
Default Value: N
|
| 9 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_CS.OPRID
|
| 10 |
DTTM_STAMP |
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.
|
| 11 |
TERM_SUMMARY |
Character(1) |
VARCHAR2(1) NOT NULL |
Term Summary
A=All Terms
B=Current and Future Terms
C=Current Term Only
F=Future Only
Default Value: A
|
| 12 |
TRANS_SORT_1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Sort Field 1
A=Due Date
B=Item Number All
C=Item Description
E=Transaction Date
G=Amount
J=Account Number
K=Term
L=Session
M=Academic Year
P=Student ID (Third Party)
Q=Student Name (Third Party)
|
| 13 |
TRANS_SORT_2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Sort Field 2
Prompt Table:
BI_SORT_TRAN_VW
|
| 14 |
TRANS_SORT_3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Sort Field 3
Prompt Table:
BI_SORT_TRAN_VW
|
| 15 |
TRANS_SORT_4 |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Sort Field 4
Prompt Table:
BI_SORT_TRAN_VW
|
| 16 |
SUB_TOTAL_BY_1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Subtotal By
Y/N Table Edit
Default Value: N
|
| 17 |
SUMM_FIELD_1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Summarization Field 1
A=Item Number All
B=Item Description
C=Item Type
D=Account Number
E=Item Nbr - Refund/Payment Only
F=Item Type Code
G=Student ID (Third Party)
H=Student Name (Third Party)
|
| 18 |
SUMM_FIELD_2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Summarization Field 2
Prompt Table:
BI_SUMM_FLD_VW
|
| 19 |
BILL_SORT_1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Bill Sort Field 1
A=Name
B=Zip Code
C=Total Amount Due
D=Academic Program
E=Academic Level
F=Invoice Number
G=Campus
H=Tuition Residency
I=Academic Load
J=Student ID
K=Country
L=Corporation ID
M=Student Enrollment Block
N=Career
Default Value: A
|
| 20 |
BILL_SORT_2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Bill Sort Field 2
Prompt Table:
BI_SORT_IVC_VW
|
| 21 |
BILL_SORT_3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Bill Sort Field 3
Prompt Table:
BI_SORT_IVC_VW
|
| 22 |
BILL_SORT_4 |
Character(1) |
VARCHAR2(1) NOT NULL |
Bill Sort Field 4
Prompt Table:
BI_SORT_IVC_VW
|
| 23 |
REPORT_DEFN_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Report Name (see PSXPRPTDEFN).
Default Value: SSF_PRNT_INV
Prompt Table:
SSF_PRPTDEFN_VW
|
| 24 |
TMPLDEFN_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Template ID (see PSXPTMPLDEFN).
Prompt Table:
PSXPRPTTMPL_VW1
|
| 25 |
SSF_EXTR_BNK_INFO |
Character(1) |
VARCHAR2(1) NOT NULL |
Extract Bank Information
Y/N Table Edit
|
| 26 |
SSF_TPC_STDCHG_DEF |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Cross Ref Student Charge
Y/N Table Edit
Default Value: N
|