PROFILE_PARC_VW(SQL View) |
Index Back |
|---|
| SELECT a.SetID , a.Profile_ID , a.EffDt , A.PAR_PROFILE_SW , A.PAR_TAG_SW , A.PAR_DESCR_SW , A.PAR_ASSET_CLASS_SW , A.PAR_ACQUIS_CD_SW , A.PAR_CUSTODIAN_SW , A.PAR_LOCATION_SW , A.PAR_LICENSE_SW , A.PAR_INDEX_SW , A.PAR_INVENTOR_DT_SW , A.PAR_CAP_METHOD_SW FROM PS_PROFILE_PARCHD a WHERE a.Effdt = ( SELECT MAX(B.Effdt) FROM PS_PROFILE_PARCHD B WHERE b.Setid = a.SetID AND b.Profile_Id = a.Profile_ID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SETID_TBL |
| 2 | PROFILE_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Asset Profile ID
Prompt Table: PROFILE_TBL |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | PAR_PROFILE_SW | Character(1) | VARCHAR2(1) NOT NULL |
Asset Profile
Y/N Table Edit Default Value: Y |
| 5 | PAR_TAG_SW | Character(1) | VARCHAR2(1) NOT NULL |
Tag Number
Y/N Table Edit |
| 6 | PAR_DESCR_SW | Character(1) | VARCHAR2(1) NOT NULL |
Copy Description
Y/N Table Edit |
| 7 | PAR_ASSET_CLASS_SW | Character(1) | VARCHAR2(1) NOT NULL |
Copy Asset Class from Parent
Y/N Table Edit |
| 8 | PAR_ACQUIS_CD_SW | Character(1) | VARCHAR2(1) NOT NULL |
Acquisition Code
Y/N Table Edit |
| 9 | PAR_CUSTODIAN_SW | Character(1) | VARCHAR2(1) NOT NULL |
Custodian Fields
Y/N Table Edit |
| 10 | PAR_LOCATION_SW | Character(1) | VARCHAR2(1) NOT NULL |
Location Fields
Y/N Table Edit |
| 11 | PAR_LICENSE_SW | Character(1) | VARCHAR2(1) NOT NULL |
License Fields
Y/N Table Edit |
| 12 | PAR_INDEX_SW | Character(1) | VARCHAR2(1) NOT NULL |
Index
Y/N Table Edit |
| 13 | PAR_INVENTOR_DT_SW | Character(1) | VARCHAR2(1) NOT NULL |
Inventory Date
Y/N Table Edit |
| 14 | PAR_CAP_METHOD_SW | Character(1) | VARCHAR2(1) NOT NULL |
Capitalization Method
Y/N Table Edit |