| # |
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 |
ACCOUNT_TYPE_SF |
Character(3) |
VARCHAR2(3) NOT NULL |
Account Type
|
| 3 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 4 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
Default Value: ACCT_TYP_TBL_SF.DESCR
|
| 5 |
BALANCE_FWD_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Balance forward indicator.
Y/N Table Edit
Default Value: N
|
| 6 |
ACCT_NUM_PREFIX |
Character(7) |
VARCHAR2(7) NOT NULL |
Account Nbr Prefix
Default Value: 0000000
|
| 7 |
ACCT_PER_TERM |
Character(1) |
VARCHAR2(1) NOT NULL |
Account Per Term
Y/N Table Edit
Default Value: N
|
| 8 |
PRIMARY_ACCOUNT |
Character(1) |
VARCHAR2(1) NOT NULL |
Primary Account
Y/N Table Edit
Default Value: N
|
| 9 |
CANCEL_CLASS |
Character(1) |
VARCHAR2(1) NOT NULL |
Include in Class Cancellation
Y/N Table Edit
Default Value: N
|
| 10 |
EXCLUDE_AGE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude From Aging Total
Y/N Table Edit
Default Value: N
|
| 11 |
PMT_PLAN_ACCT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Plan Account
Y/N Table Edit
Default Value: N
|
| 12 |
LATE_FEE_ACCT_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Late Fee Account
Y/N Table Edit
Default Value: N
|
| 13 |
LATE_FEE_CODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Late Fee Code
Prompt Table:
LATE_CD_EMP_VW
|
| 14 |
LATE_FEE_ACCT_ORG |
Character(1) |
VARCHAR2(1) NOT NULL |
Ext Org Late Fee Account
Y/N Table Edit
Default Value: N
|
| 15 |
LATE_FEE_CODE_ORG |
Character(6) |
VARCHAR2(6) NOT NULL |
Ext Org Late Fee Code
Prompt Table:
LATE_CD_ORG_VW
|
| 16 |
INCLUDE_IN_BALANCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Include in Balance
Y/N Table Edit
Default Value: Y
|
| 17 |
INCLUDE_BILLING |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Billing
Y/N Table Edit
Default Value: N
|
| 18 |
INCLUDE_TRANSFER |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Transfers
Y/N Table Edit
Default Value: N
|
| 19 |
INCLUDE_PREPAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Pre-Pay
Y/N Table Edit
Default Value: N
|
| 20 |
MOVE_EXCESS_FA |
Character(1) |
VARCHAR2(1) NOT NULL |
Move Excess Financial Aid
Y/N Table Edit
Default Value: N
|
| 21 |
MOVE_EXCESS_PMT |
Character(1) |
VARCHAR2(1) NOT NULL |
Move Excess Payment
Y/N Table Edit
Default Value: N
|
| 22 |
MOVE_EXCESS_WAIVER |
Character(1) |
VARCHAR2(1) NOT NULL |
Move Excess Waiver
Y/N Table Edit
Default Value: N
|
| 23 |
UNAPP_PMT_CREDHIST |
Character(1) |
VARCHAR2(1) NOT NULL |
View Unappld Pymt Credit Hist
Y/N Table Edit
Default Value: N
|
| 24 |
SF_ACCOUNT_CLASS |
Character(10) |
VARCHAR2(10) NOT NULL |
Account Class
Prompt Table:
SF_ACCT_CLASS
|