RE_AST_PROF_VW(SQL View) |
Index Back |
|---|---|
Asset Profile ViewAsset Profile View |
| SELECT A.BUSINESS_UNIT ,A.ASSET_ID ,PT.FINANCIAL_ASSET_SW ,PT.ACQUISITION_CD ,PDT.CATEGORY FROM PS_ASSET A ,PS_PROFILE_TBL PT , PS_PROFILE_DET_TBL PDT , PS_BUS_UNIT_TBL_AM BU WHERE A.PROFILE_ID = PT.PROFILE_ID AND PT.SETID = PDT.SETID AND PT.PROFILE_ID = PDT.PROFILE_ID AND PT.PROFILE_ACTIVE_SW <> 'N' AND A.BUSINESS_UNIT = BU.BUSINESS_UNIT AND PDT.BOOK = BU.LEASE_BOOK AND PDT.SETID = ( SELECT C.SETID FROM PS_SET_CNTRL_REC C WHERE C.SETCNTRLVALUE = A.BUSINESS_UNIT AND C.RECNAME = 'PROFILE_TBL') AND PDT.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_PROFILE_DET_TBL D WHERE D.SETID = PDT.SETID AND D.PROFILE_ID = PDT.PROFILE_ID AND D.BOOK = PDT.BOOK AND D.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 3 | FINANCIAL_ASSET_SW | Character(1) | VARCHAR2(1) NOT NULL |
Capitalized Asset
N=Non Cap Y=Capitalize |
| 4 | ACQUISITION_CD | Character(1) | VARCHAR2(1) NOT NULL |
Acquisition Code
C=Constructed D=Donated I=Trade In K=Like Exchange L=Leased P=Purchased T=Transferred |
| 5 | CATEGORY | Character(5) | VARCHAR2(5) NOT NULL | Asset Category |