| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 3 |
INVOICE_ID |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice Number
|
| 4 |
SSF_PREC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Type
|
| 5 |
ITEM_NBR |
Character(15) |
VARCHAR2(15) NOT NULL |
Item Nbr
Prompt Table:
ITEM_TYPE_TBL
|
| 6 |
SSF_DLINE_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Line Sequence Nbr
|
| 7 |
SSF_REL_INVOICE_ID |
Character(22) |
VARCHAR2(22) NOT NULL |
Related Invoice ID
|
| 8 |
SSF_RELINV_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Related Invoice Amount
|
| 9 |
COMMON_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Common ID to store Personal ID / Ext Org ID value
|
| 10 |
SA_ID_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
ID Type
O=Organization
P=Person
|
| 11 |
ITEM_TYPE |
Character(12) |
VARCHAR2(12) NOT NULL |
Item Type
|
| 12 |
ITEM_TYPE_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Item Type Description
|
| 13 |
DUE_DT |
Date(10) |
DATE |
Expected Birth Date
|
| 14 |
ITEM_TYPE_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Item Type Code
A=Application Fee
B=Billing Only
C=Charge
D=Deposit
F=Financial Aid
G=GL Interface Only
H=Withholding
I=Interest
L=Pre-Paid Tuition
P=Payment
R=Refund
T=Transfers
V=Contributor Relations
W=Waiver
X=Write-off
Z=Pay Plan Credit
|
| 15 |
ITEM_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Item Description
|
| 16 |
POSTED_DATE |
Date(10) |
DATE |
Date Posted
|
| 17 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 18 |
LINE_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Line Amount
|
| 19 |
ITEM_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Item Amount
|
| 20 |
ITEM_BALANCE |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Item Balance
|
| 21 |
ACCOUNT_NBR |
Character(10) |
VARCHAR2(10) NOT NULL |
Account Nbr
Prompt Table:
ACCOUNT_SF
|
| 22 |
ACCOUNT_TERM |
Character(4) |
VARCHAR2(4) NOT NULL |
Account Term
Prompt Table:
TERM_VAL_TBL
|
| 23 |
ITEM_TERM |
Character(4) |
VARCHAR2(4) NOT NULL |
Item Term
|
| 24 |
TERM_DESCR |
Character(10) |
VARCHAR2(10) NOT NULL |
Term Descr
|
| 25 |
SESSION_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Session
1=Regular Academic Session
10W=10 Week
12W=Twelve Week
4W1=Four Week - First
4W2=Four Week - Second
4W3=Four Week - Third
4W4=Four Week - Fourth
6W1=Six Week - First
6W2=Six Week - Second
8W1=Eight Week - First
8W2=Eight Week - Second
A11=Medical Period 1, 4 Weeks
A12=Medical Period 1, 8 Weeks
A13=Medical Pd 1, 12 Weeks
A21=Medical Period 2, 4 Weeks
A22=Medical Period 2, 8 Weeks
A23=Medical Period 2, 12 Week
FYR=Full Year
MIN=Mini Session
OEE=Open Entry/Open Exit
SM1=Semester 1
SM2=Semester 2
|
| 26 |
SSF_CSESS_DESCRSH |
Character(10) |
VARCHAR2(10) NOT NULL |
Class Session Descr Short
|
| 27 |
ACAD_YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Academic Year
|
| 28 |
REF1_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Reference Nbr
|
| 29 |
LINE_REASON_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Line Reason Code
|
| 30 |
BALANCE_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Charge Balance
|
| 31 |
PAYMENT_ID_NBR |
Number(12,0) |
DECIMAL(12) NOT NULL |
Payment ID Nbr
|
| 32 |
REFUND_NBR |
Number(12,0) |
DECIMAL(12) NOT NULL |
Refund Nbr
|
| 33 |
CONTRACT_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Contract ID
|
| 34 |
NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Name
|
| 35 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract Number
|
| 36 |
SSF_REF_STDNT_CHRG |
Character(1) |
VARCHAR2(1) NOT NULL |
Cross Reference Student Charge
|
| 37 |
SSF_TPCON_USERDEF1 |
Character(50) |
VARCHAR2(50) NOT NULL |
Third Party Contract User Defined Field 1.
|
| 38 |
SSF_TPCON_USERDEF2 |
Character(50) |
VARCHAR2(50) NOT NULL |
Third Party Contract User Defined Field 2.
|
| 39 |
SSF_TPCON_USERDEF3 |
Character(50) |
VARCHAR2(50) NOT NULL |
Third Party Contract User Defined Field 3.
|
| 40 |
SSF_TPCON_USERDEF4 |
Character(50) |
VARCHAR2(50) NOT NULL |
Third Party Contract User Defined Field 4.
|
| 41 |
SSF_TPCON_USERDEF5 |
Character(50) |
VARCHAR2(50) NOT NULL |
Third Party Contract User Defined Field 5.
|
| 42 |
SSF_TPSTD_USERDEF1 |
Character(50) |
VARCHAR2(50) NOT NULL |
Third Party Student User Defined Field 1.
|
| 43 |
SSF_TPSTD_USERDEF2 |
Character(50) |
VARCHAR2(50) NOT NULL |
Third Party Student User Defined Field 2.
|
| 44 |
SSF_TPSTD_USERDEF3 |
Character(50) |
VARCHAR2(50) NOT NULL |
Third Party Student User Defined Field 3.
|
| 45 |
SSF_TPSTD_USERDEF4 |
Character(50) |
VARCHAR2(50) NOT NULL |
Third Party Student User Defined Field 4.
|
| 46 |
SSF_TPSTD_USERDEF5 |
Character(50) |
VARCHAR2(50) NOT NULL |
Third Party Student User Defined Field 5.
|
| 47 |
SSF_RELINV_DUE |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Related Invoice Due
|
| 48 |
SSF_RELINV_ADJ |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Related Invoice Adjustments
|
| 49 |
SSF_SUM_PRINT_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Amount
|
| 50 |
SSF_SUM_FLD1_VALUE |
Character(30) |
VARCHAR2(30) NOT NULL |
Summary Field1 Value
|
| 51 |
SSF_SUM_FLD2_VALUE |
Character(30) |
VARCHAR2(30) NOT NULL |
Summary Field2 Value
|