| # |
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:
GROUP_CONT_VW
|
| 2 |
GROUP_ID_SF |
Character(15) |
VARCHAR2(15) NOT NULL |
Group ID
|
| 3 |
GROUP_LINE_NBR |
Number(6,0) |
INTEGER NOT NULL |
Group Line Number
Default Value: 999999
|
| 4 |
ACCOUNT_TYPE_SF |
Character(3) |
VARCHAR2(3) NOT NULL |
Account Type
Prompt Table:
ACCT_TYP_TBL_SF
|
| 5 |
ITEM_TYPE |
Character(12) |
VARCHAR2(12) NOT NULL |
Item Type
Prompt Table:
%EDITTABLE
|
| 6 |
ITEM_EFFECTIVE_DT |
Date(10) |
DATE |
Item Effective Date
Default Value: %DATE
|
| 7 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 8 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PEOPLE_SRCH
|
| 9 |
DUE_DT |
Date(10) |
DATE |
Due Date
|
| 10 |
REF1_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Reference Nbr
|
| 11 |
ACAD_CAREER |
Character(4) |
VARCHAR2(4) NOT NULL |
Academic Career
BAC=Bachelor (NLD)
BBL=Vocational Coaching (NLD)
BOL=Vocational Training (NLD)
BUSN=Graduate Business
CNED=Continuing Education
CRED=Semester Credit
EDU=Education (NLD)
EXED=Extended Education
GRAD=Graduate
LAW=Law
MEDS=Medical School
NONA=Non Award
PGRD=Postgraduate
RSCH=Research
TECH=Technical
UENG=Undergraduate Engineering
UGRD=Undergraduate
VAVO=Advanced General Educ. (NLD)
VETM=Veterinary Medicine
Prompt Table:
STDNT_CAREER
|
| 12 |
STDNT_CAR_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Student Career Nbr
Prompt Table:
STDNT_CAR_SEQ
|
| 13 |
STRM |
Character(4) |
VARCHAR2(4) NOT NULL |
Term
Prompt Table:
SF_TERM_VW
|
| 14 |
CLASS_NBR |
Number(5,0) |
INTEGER NOT NULL |
Class Nbr
Prompt Table:
STDNT_ENRL
|
| 15 |
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
Prompt Table:
SESSION_TBL
|
| 16 |
FINANCE_CHARGE |
Character(8) |
VARCHAR2(8) NOT NULL |
Finance Charge
|
| 17 |
ENCUMBRANCE_DT |
Date(10) |
DATE |
Encumbrance Date
|
| 18 |
ENCUMBERED_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Amount Encumbered
|
| 19 |
ACAD_YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Academic Year
|
| 20 |
ITEM_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Item Amount
|
| 21 |
PAYMENT_PRIORITY |
Character(8) |
VARCHAR2(8) NOT NULL |
Payment Priority
|
| 22 |
CHARGE_PRIORITY |
Character(8) |
VARCHAR2(8) NOT NULL |
Charge Priority List
Prompt Table:
PMT_CHRG_TBL
|
| 23 |
POST_DT |
Date(10) |
DATE |
The Date a transaction was Posted.
|
| 24 |
SSF_ERROR_WARN |
Character(1) |
VARCHAR2(1) NOT NULL |
Field to hold translate values for Message Types - Error/Warning/Message
E=Error
M=Message
W=Warning
|
| 25 |
POST_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Line Post Flag
D=Deleted
N=Not Posted
Y=Posted
Y/N Table Edit
Default Value: N
|
| 26 |
PRIOR_POST_VAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Prior Post Value
|
| 27 |
ACCOUNT_NBR |
Character(10) |
VARCHAR2(10) NOT NULL |
Account Nbr
|
| 28 |
ACCOUNT_TERM |
Character(4) |
VARCHAR2(4) NOT NULL |
Account Term
|
| 29 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table:
INSTITUTION_TBL
|
| 30 |
ITEM_NBR |
Character(15) |
VARCHAR2(15) NOT NULL |
Item Nbr
|
| 31 |
FEE_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Fee Code
|
| 32 |
SEL_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Tuition Group
|
| 33 |
ADM_APPL_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Application Nbr
Prompt Table:
ADM_APPL_DT_VW
|
| 34 |
PAYMENT_ID_NBR |
Number(12,0) |
DECIMAL(12) NOT NULL |
Payment ID Nbr
Prompt Table:
%EDITTABLE2
|
| 35 |
LINE_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Line Status
A=Active
C=Contingent
D=Disputed
H=Hold
R=Reversed
Default Value: A
|
| 36 |
LINE_ACTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Line Action
APP=Application Generated
BCK=Backing Out Term Fees
CCP=Credit Card Payment
CRV=Charge Reversal
CSH=Cashiering
GRP=Group Posting
INT=Multi Year Interest Calc
LAT=Late Fee Processing
NRA=Tax Calculations
PAY=Payment Posted
PMT=Excess Payment
QBK=Quick Post Back Up
QCK=Posting Page
REF=Refund Processing
SSP=Self service payment
SYS=System Generated
TAX=Tax Adjustment Page
TPA=Third Party - Online
TUI=Tuition Calculation
WRO=Writeoff Processing
Default Value: GRP
|
| 37 |
LINE_REASON_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Line Reason Code
|
| 38 |
PAYMENT_METHOD |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Method
CC=Credit Card
CHK=Check
CSH=Cash
DB=Debit Card
EC=Electronic Check
EFT=Electronic Funds Transfer
LBX=Lockbox
TPC=Third Party Check
WIR=Wire Transfer
|
| 39 |
CHECK_NUM_SF |
Character(30) |
VARCHAR2(30) NOT NULL |
Check Nbr
|
| 40 |
THIRD_PARTY |
Character(30) |
VARCHAR2(30) NOT NULL |
Third Party Check Name
|
| 41 |
CREDIT_CARD_NBR |
Character(44) |
VARCHAR2(44) NOT NULL |
Card Number
|
| 42 |
CREDIT_CARD_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Credit Card Type
AE=American Express
DC=Diners' Club
DI=Diners Club
MC=MasterCard
VI=VISA
Prompt Table:
CREDIT_CARD_TYP
|
| 43 |
CREDIT_CARD_EXP_DT |
Date(10) |
DATE |
Expiration Date
|
| 44 |
CREDIT_CARD_ISSUER |
Character(20) |
VARCHAR2(20) NOT NULL |
Credit Card Issuer
|
| 45 |
CREDIT_CARD_HOLDER |
Character(30) |
VARCHAR2(30) NOT NULL |
Credit Card Holder
|
| 46 |
FED_RSRV_BANK_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Federal Reserve Bank ID
|
| 47 |
SSF_BNK_ACCT_NUM |
Character(44) |
VARCHAR2(44) NOT NULL |
Bank Account Number
|
| 48 |
BANK_ACCT_TYP |
Character(1) |
VARCHAR2(1) NOT NULL |
Bank Account Type
C=Checking
S=Savings
|
| 49 |
BANK_ACCT_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Bank Account Holder Name
|
| 50 |
SF_REVERSAL_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Reversal Indicator
Y/N Table Edit
Default Value: N
|
| 51 |
TENDER_SPEC |
Character(1) |
VARCHAR2(1) NOT NULL |
Tender Specific
|
| 52 |
TENDER_CATEGORY |
Character(3) |
VARCHAR2(3) NOT NULL |
Tender Category
CC=Credit Card
CCI=Credit Card In
CCO=Credit Card Out
CK=Check
CKI=Check In
CKO=Check Out
CS=Cash
CSI=Cash In
CSO=Cash Out
DB=Debit Card
DBI=Debit Card In
DBO=Debit Card Out
DD=Direct Deposit
DDI=Direct Debit
DDO=Direct Deposit
EC=Electronic Check
TP=Third Party Check
TPI=Third Party Check In
WIR=Wire Transfer
|
| 53 |
TRACER_NBR |
Character(30) |
VARCHAR2(30) NOT NULL |
Tracer Number
|
| 54 |
OPRID_QCKPOST |
Character(30) |
VARCHAR2(30) NOT NULL |
Quick Post Oprid
|
| 55 |
DEPOSIT_NBR |
Number(12,0) |
DECIMAL(12) NOT NULL |
Deposit Nbr
|
| 56 |
REFUND_NBR |
Number(12,0) |
DECIMAL(12) NOT NULL |
Refund Nbr
|
| 57 |
EXT_ORG_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
External Org ID
Prompt Table:
EXT_ORG_TBL
|
| 58 |
REFUND_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Refund ID
|
| 59 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract Number
Prompt Table:
TP_CONTRACT_VW
|
| 60 |
COLLECTION_ID |
Number(12,0) |
DECIMAL(12) NOT NULL |
Collection ID
|
| 61 |
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
|
| 62 |
OVERRIDE_APPL_NBR |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Application Number
Y/N Table Edit
Default Value: N
|
| 63 |
ACAD_PROG |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Program
|
| 64 |
ACAD_PROG2 |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Program
|
| 65 |
ACAD_PROG3 |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Program 3
|
| 66 |
EXTRA_REFUND_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Extra Refund Flag
|
| 67 |
ORG_GROUP_ID_SF |
Character(15) |
VARCHAR2(15) NOT NULL |
Original Group ID
|
| 68 |
ORG_GROUP_LINE_NBR |
Number(6,0) |
INTEGER NOT NULL |
Original Group Line Nbr
|
| 69 |
RECEIPT_NBR |
Number(12,0) |
DECIMAL(12) NOT NULL |
Receipt Number
|
| 70 |
AGING_DT |
Date(10) |
DATE |
Aging Date
|
| 71 |
AGING_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Aging Flag
Y/N Table Edit
Default Value: N
|
| 72 |
RESTRICT_ACCT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Pay Entered Acct Only
Y/N Table Edit
Default Value: N
|
| 73 |
EXC_ACCT_TYPE_SF |
Character(3) |
VARCHAR2(3) NOT NULL |
Excess Account Type SF
Prompt Table:
ACCT_TYP_SF_VW
|
| 74 |
EXC_ACCT_TYPE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Excess Account Type Flag
Y/N Table Edit
Default Value: N
|
| 75 |
CHARGE_SET_TABLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Charge Set Table Flag
Default Value: N
|
| 76 |
EMPLID_SET_TABLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Emplid Set Table
Default Value: N
|
| 77 |
CONTRACT_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Contract ID
Prompt Table:
PEOPLE_SRCH_SF
|
| 78 |
WRITEOFF_BY |
Character(2) |
VARCHAR2(2) NOT NULL |
Writeoff By
01=Entire Balance
02=Account Number
03=By Item Type
04=Account Type
|
| 79 |
SRVC_IND_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Service Indicator Cd
Prompt Table:
%EDITTABLE4
|
| 80 |
COURSE_LIST |
Character(9) |
VARCHAR2(9) NOT NULL |
Course List
|
| 81 |
CRSE_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
Course ID
|
| 82 |
BILLING_DT |
Date(10) |
DATE |
Billing Date
|
| 83 |
ACTUAL_BILLING_DT |
Date(10) |
DATE |
Actual Billing Date
|
| 84 |
BILLING_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Billing Flag
Y/N Table Edit
Default Value: N
|
| 85 |
WAIVER_CODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Waiver Code
|
| 86 |
PRIORITY |
Number(3,0) |
SMALLINT NOT NULL |
Priority
|
| 87 |
PRIORITY_PMT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Priority Flag
|
| 88 |
TRANS_FEE_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Transaction Fee Code
|
| 89 |
BILLING_CAREER |
Character(4) |
VARCHAR2(4) NOT NULL |
Billing Career
|
| 90 |
LATE_FEE_CODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Late Fee Code
|
| 91 |
CUR_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
|
| 92 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 93 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 94 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 95 |
ORIGNL_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 96 |
ORIGNL_ITEM_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Item Amount
|
| 97 |
CREATE_ITEM |
Character(1) |
VARCHAR2(1) NOT NULL |
Create Item
Y/N Table Edit
Default Value: N
|
| 98 |
ITEM_NBR_SOURCE |
Character(15) |
VARCHAR2(15) NOT NULL |
Item Nbr - Src Charge Nbr
|
| 99 |
TAX_AUTHORITY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Tax Authority
|
| 100 |
GL_FROM_SUBFEE |
Character(1) |
VARCHAR2(1) NOT NULL |
GL from Sub Fees
|
| 101 |
CLASS_PRICE_DTTM |
DateTime(26) |
TIMESTAMP |
Class Price Date Time
|
| 102 |
AID_YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Aid Year
Prompt Table:
AID_YEAR_TBL
|
| 103 |
DISBURSEMENT_DATE |
Date(10) |
DATE |
Disbursement Date
|
| 104 |
ORIG_EFF_DT |
Date(10) |
DATE |
Original Effective Date
|
| 105 |
SF_DEPOSIT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Deposit ID
|
| 106 |
SF_PMT_REF_NBR |
Character(12) |
VARCHAR2(12) NOT NULL |
Reference Nbr
|
| 107 |
BANK_CD |
Character(11) |
VARCHAR2(11) NOT NULL |
Bank ID
|
| 108 |
INVOICE_ID |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice Number
Prompt Table:
%EDITTABLE3
|
| 109 |
SSF_RESTRICT_INV |
Character(1) |
VARCHAR2(1) NOT NULL |
This field indicates that the payment will be held until an invoice is provided.
Y/N Table Edit
Default Value: N
|
| 110 |
CR_CARD_DIGITS |
Character(4) |
VARCHAR2(4) NOT NULL |
Card Number's Last Four Digits
|
| 111 |
SSF_INSTMNT_ID |
Number(3,0) |
SMALLINT NOT NULL |
Installment ID
|