RE_PROF_DET_VW(SQL View) |
Index Back |
|---|---|
Lease Asset ProfilesLease Asset Profiles |
| SELECT DISTINCT A.SETID , A.PROFILE_ID , A.DESCR , A.FINANCIAL_ASSET_SW , C.DEPR_STATUS , A.ACQUISITION_CD , A.ASSET_TYPE ,D.BUSINESS_UNIT FROM PS_PROFILE_TBL A ,PS_PROFILE_DET_TBL C ,PS_BUS_UNIT_TBL_AM D WHERE A.SETID = C.SETID AND D.LEASE_BOOK = C.BOOK AND C.PROFILE_ID = A.PROFILE_ID AND C.EFFDT = ( SELECT MAX(C_ED.EFFDT) FROM PS_PROFILE_DET_TBL C_ED WHERE C_ED.SETID = C.SETID AND C_ED.PROFILE_ID = C.PROFILE_ID AND C_ED.BOOK = C.BOOK AND C_ED.EFFDT <= %CurrentDateIn) AND A.PROFILE_ACTIVE_SW <> 'N' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | PROFILE_ID |
Character(10) | VARCHAR2(10) NOT NULL | Asset Profile ID |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | FINANCIAL_ASSET_SW | Character(1) | VARCHAR2(1) NOT NULL |
Capitalized Asset
N=Non Cap Y=Capitalize |
| 5 | DEPR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Depreciation Status
D=Depreciable N=Non Depreciable |
| 6 | 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 |
| 7 | ASSET_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Asset Type
010=IT Hardware 020=IT Software 040=Equipment 050=Property 060=Fleet 070=Machinery 080=Furniture 090=Facility 100=Intangible 200=Asset Retirement Obligations 999=Other |
| 8 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |