OPT_FEE_TERM(SQL Table) |
Index Back |
|---|---|
Optional Fee Terms |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPT_FEE_CD_TBL.SETID Prompt Table: SP_SETID_NONVW |
| 2 | FEE_CD |
Character(6) | VARCHAR2(6) NOT NULL |
Fee Code
Default Value: OPT_FEE_CD_TBL.FEE_CD Prompt Table: OPT_FEE_TBL |
| 3 | STRM |
Character(4) | VARCHAR2(4) NOT NULL |
Term
Default Value: OPR_DEF_TBL_CS.STRM Prompt Table: TERM_VAL_TBL |
| 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: SP_ITEMCH_NONVW |
| 6 | DUE_DATE_CODE | Character(8) | VARCHAR2(8) NOT NULL |
Due Date Code
Prompt Table: DUE_DATE_CD_VW1 |
| 7 | OPT_FEE_START_DATE | Date(10) | DATE | Optional Fee Start Date |
| 8 | OPT_FEE_STOP_DATE | Date(10) | DATE | Optional Fee Stop Date |
| 9 | NO_CHANGE_DATE | Date(10) | DATE | No Change Date |
| 10 | ONE_FEE_ALL_CAR | Character(1) | VARCHAR2(1) NOT NULL |
One Fee for All Careers
Y/N Table Edit Default Value: N |