PKG_BSE_CMP_VW(SQL View) |
Index Back |
|---|---|
Packaging Component ViewSalary Packaging - Component View |
| SELECT A.COMPONENT ,A.EFFDT ,A.EFF_STATUS ,A.DESCR ,A.DESCRSHORT ,A.COMPONENT_TYPE FROM PS_PKG_BSE_CMP_TBL A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_PKG_BSE_CMP_TBL B WHERE A.COMPONENT = B.COMPONENT AND B.EFFDT < %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SUB_COMPONENT |
Character(8) | VARCHAR2(8) NOT NULL | Sal package - Packaging Sub Component |
| 2 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 6 | COMPONENT_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Sal Package - Component Type
AMT=Flat Amount FAIR=Airline FBRD=Board FENT=Tax-exempt Body Entertainment FEXP=Expenses FHSG=Housing FLAA=Living Away From Home Allowanc FLOA=Loan FPRK=Car Parking FPTY=Property FRSD=Residual FVEH=Motor Vehicle FWVR=Debt Waiver HOM=Home Office Lease PCT=Pct of Contributing Components PCTB=Percentage of Benefits Base |