PIN_NUMEFFDTDefault Value: %date
GPAU_TXFRE_CLAIMEDSEQ_NUM5GPAU_HECSDTL_VW(SQL View) |
Index Back |
|---|---|
HECS Rates Detail ViewThis view will be used to display the HECS rates that PeopleSoft Australia has delivered with the product. This view retrieve the data from the tables GP_PIN, GP_BRACKET and GP_BRACKET_DTL. It extracts the records for the element TAX BR HECS RATE, which is the bracket for HECS rates. The fields that will be extracted include Pin Num, Effective Date, Seq Num, Data of Key 1 and Data Num of Value 1. |
| SELECT A.PIN_NUM ,B.EFFDT ,%Substring(C.DATA_KEY1,1,1) ,C.SEQ_NUM5 ,C.DATA_KEY1_DEC ,C.DATA_KEY2_DEC ,C.DATA_VAL1_DEC FROM PS_GP_PIN A , PS_GP_BRACKET B , PS_GP_BRACKET_DTL C WHERE A.PIN_CODE = 'TAX BR HELP RATE AUS' AND B.PIN_NUM = A.PIN_NUM AND C.PIN_NUM = B.PIN_NUM AND C.EFFDT = B.EFFDT AND C.DATA_KEY1 <> 'NA' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PIN_NUM |
Number(8,0) | INTEGER NOT NULL | PIN Number |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | GPAU_TXFRE_CLAIMED |
Character(1) | VARCHAR2(1) NOT NULL | Tax free treshold claimed |
| 4 | SEQ_NUM5 |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 5 | DATA_KEY1_DEC | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Data Key - Decimal |
| 6 | DATA_KEY2_DEC | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Data Key - Decimal |
| 7 | DATA_VAL1_DEC | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Data Value - Decimal |