PIN_NUMEFFDTDefault Value: %date
GPAU_TXFRE_CLAIMEDSEQ_NUM5GPAU_SFSSDTL_VW(SQL View) |
Index Back |
|---|---|
SFSS Rates Detail ViewThis view will be used to display the SFSS 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 SFSS RATE, which is the bracket for SFSS 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 SFSS 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 |