SSF_HECS_FE_TBL(SQL Table) |
Index Back |
|---|---|
HECS Fees Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | SSF_HECS_CODE |
Character(6) | VARCHAR2(6) NOT NULL | HECS Fee Code |
| 3 | STRM |
Character(4) | VARCHAR2(4) NOT NULL | Term |
| 4 | SSR_COHORT_YR |
Character(4) | VARCHAR2(4) NOT NULL | Cohort Year |
| 5 | SSR_HECS_BAND_ID |
Character(2) | VARCHAR2(2) NOT NULL |
HECS Band ID
Prompt Table: SSR_HECSBND_AUS |
| 6 | SSF_HECS_BAND_CHRG | Number(17,2) | DECIMAL(16,2) NOT NULL | HECS Band Charge |
| 7 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: INSTALLATION.EXCHNG_TO_CURRENCY Prompt Table: CURRENCY_CD_TBL |
| 8 | SSR_DEEWR_E392_AUS | Character(2) | VARCHAR2(2) NOT NULL |
Element 392
0=Contribution Exempt 1=Pre 2005 HECS Post 1996 2=Post 2005 CSP Pre 2008 3=2008 Commencing 4=Pre 2008 5=2009 Commencing 6=2010 Commencing 7=2013 Commencing |