PIN_NUMEFFDTDefault Value: %date
SEQ_NUM5GPAU_FTBDTL_VW(SQL View) |
Index Back |
|---|---|
FTB Rates Detail ViewThis view will be used to display the FTB 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 FTB RATE, which is the bracket for FTB 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 ,C.SEQ_NUM5 ,C.DATA_KEY1 ,C.DATA_VAL2 ,C.DATA_VAL1_DEC FROM PS_GP_PIN A , PS_GP_BRACKET B , PS_GP_BRACKET_DTL C WHERE A.PIN_NM = 'TAX BR FTB RATE' AND B.PIN_NUM = A.PIN_NUM AND C.PIN_NUM = B.PIN_NUM AND C.EFFDT = B.EFFDT |
| # | 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 | SEQ_NUM5 |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 4 | DATA_KEY1 | Character(18) | VARCHAR2(18) NOT NULL | Data Key - Character |
| 5 | DATA_VAL2 | Character(18) | VARCHAR2(18) NOT NULL | Data Value - Character |
| 6 | DATA_VAL1_DEC | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Data Value - Decimal |