PC_AM_EXP2_VW(SQL View) |
Index Back |
---|---|
PC AM Exp: Express viewViews combination of activity level rules, asset definition and the relationship between assets and a project. |
SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.ACTIVITY_ID , 'CLS' , C.BUSINESS_UNIT_AM , C.ASSET_ID , 'Y' , 'U' , 'U' ,%subrec(PC_AM_PDEFN_SBR, B) ,%subrec(PC_AM_DEFN_SBR, C) FROM PS_PC_AM_RULE_ACT A , PS_PC_AM_PROJ_DEFN B , PS_PC_AM_DEFN C WHERE %Join(COMMON_KEYS, PC_AM_RULE_ACT A, PC_AM_PROJ_DEFN B) AND %Join(COMMON_KEYS, PC_AM_PROJ_DEFN B, PC_AM_DEFN C) AND C.AM_DISTRIB_STATUS <> 'I' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
2 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
3 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
4 | ANALYSIS_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Analysis Type |
5 | BUSINESS_UNIT_AM | Character(5) | VARCHAR2(5) NOT NULL |
AM Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT |
6 | ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL |
Asset Identification
Default Value: NEXT |
7 | PC_AM_CAP_SW | Character(1) | VARCHAR2(1) NOT NULL |
Enable Integration
N=No Y=Yes |
8 | DEFN_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Definition Flag |
9 | PROJ_DEFN_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Project Definition Flag |
10 | ANALYSIS_GROUP | Character(5) | VARCHAR2(5) NOT NULL | Analysis Group |
11 | ANALYSIS_GROUP_AMR | Character(5) | VARCHAR2(5) NOT NULL | Retire Proceed and Cost An Grp |
12 | ANALYSIS_GROUP_RET | Character(5) | VARCHAR2(5) NOT NULL | Retirement Analysis Group |
13 | INTFC_TYPE_RET | Character(3) | VARCHAR2(3) NOT NULL |
Retirement Interface Type
AAD=Additional Cost Add ACQ=Insert Acquisition Detl ADD=Asset Add ADJ=Asset Cost Adjustment ADQ=Adjust Cost & Acquisition Detl ARA=Add Retired Assets ASD=Asset Deletion AUP=Asset Information Update BKD=Book Deletion BKS=Book Change BSD=Selective Book Delete CAP=Asset Capitalization CIC=Capitalize Into Composite CLC=Custodian/Location Change CN1=Conversion of First Book CN2=Conversion of Subsequent Books FAD=Financial & Physical Add IHI=Inventory History Insert IUI=Inter-Unit Transfer In Side IUO=Inter-Unit Transfer Out Side LAD=Leased Asset Add NAD=Non-Financial Add OPT=Open Trans Generation PHY=Physical Asset Change PRT=Partial Retirement RCT=Asset Recategorization REI=Asset Reinstatement RET=Asset Retirement TRF=Intra-Business Unit Transfer |
14 | PROFILE_ID | Character(10) | VARCHAR2(10) NOT NULL |
Asset Profile ID
Prompt Table:
PROFILE_PCAM_VW
|
15 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
16 | TAG_NUMBER | Character(12) | VARCHAR2(12) NOT NULL | Tag Number |
17 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
LOCATION_TBL
|
18 | CATEGORY | Character(5) | VARCHAR2(5) NOT NULL |
Asset Category
Prompt Table:
CATEGORY_TBL
|
19 | SERIAL_ID | Character(20) | VARCHAR2(20) NOT NULL | Serial ID |
20 | MANUFACTURER | Character(60) | VARCHAR2(60) NOT NULL |
Manufacturer Name
Prompt Table:
MANUF_FS_VW
|
21 | GROUP_ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL |
Group Asset ID
Prompt Table: PC_AM_GROUP_VW |
22 | PARENT_ID | Character(12) | VARCHAR2(12) NOT NULL |
Parent ID
Prompt Table: PARENT_ASSET_VW |
23 | PARENT_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Parent Asset Description |
24 | PARENT_ASSET_SW | Character(1) | VARCHAR2(1) NOT NULL |
Parent Asset
N=No Y=Yes Default Value: N |
25 | QUANTITY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL |
Qty Interface
Default Value: 1 |
26 | IN_SERVICE_DT | Date(10) | DATE |
In Service Date
Default Value: %DATE |
27 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table:
%EDIT_DEPT
|
28 | ASSET_OPTION | Character(3) | VARCHAR2(3) NOT NULL |
Asset Creation Option
ADD=Auto Assign New Asset ID ADJ=Adjust Existing Asset MAN=Manually Assign Asset ID Default Value: MAN |
29 | INTFC_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Interface Status
CON=Consolidated DON=Mass Changes Generated ERR=Error NEW=Mass Changes Not Generated REP=Replaced by Other Records (AP) UNI=Unitized Default Value: NEW |
30 | INTFC_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Trans Load Type |
31 | BOOK_PROCESSING_SW | Character(1) | VARCHAR2(1) NOT NULL |
Enable Book Processing
N=No Y=Yes Default Value: N |
32 | GROUP_ASSET_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Group Asset Flag
G=Group Asset M=Group Member N=None |
33 | LOCATION_EFFDT | Date(10) | DATE | Location Effective Date |
34 | TRANS_DT | Date(10) | DATE |
Transaction Date
Default Value: %DATE |
35 | ACCOUNTING_DT | Date(10) | DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
Default Value: %DATE |
36 | BOOK_EFFDT | Date(10) | DATE | Book Effective Date |
37 | TAGGABLE_SW | Character(1) | VARCHAR2(1) NOT NULL |
Taggable Asset
N=Non Taggable Asset Y=Taggable Asset |
38 | DEFAULT_PROFILE_SW | Character(1) | VARCHAR2(1) NOT NULL |
Default Books from Profile
Default Value: Y |
39 | OPEN_TRANS_ID | Number(10,0) | DECIMAL(10) NOT NULL | Open Transaction ID |
40 | AM_DISTRIB_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
AM Distribution Status
D=Distributed I=Ignore M=Modified N=Not Distributed P=Pending V=Reversed Default Value: N |
41 | REPLACE_SW | Character(1) | VARCHAR2(1) NOT NULL |
Replacement Asset
Default Value: N |
42 | 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 Default Value: C |
43 | LOAD_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
/* -> JMZ. PSOFT. 11-OCT-2002 */
New Status were added : HLD and INP for Asset Management.
/* <- JMZ. PSOFT. 11-OCT-2002 */
CON=Consolidated DON=Loaded ERR=Errored EXC=Excluded HLD=On Hold INP=In Process NEW=Pending PGI=PO Grp Incomplete REP=Replaced UNI=Unitized Default Value: NEW |
44 | SYSTEM_SOURCE | Character(3) | VARCHAR2(3) NOT NULL |
Identifies the application or source system that generated a journal entry.
Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values.
SUJ---Included a label as Product.
Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.
Default Value: BPC |
45 | APPROVAL_SW | Character(1) | VARCHAR2(1) NOT NULL |
Auto Approval Status
Default Value: Y |
46 | DISPOSAL_CODE | Character(1) | VARCHAR2(1) NOT NULL |
Retirement Type
A=Abandonment C=Cannibalize for Other Assets D=Disappeared Assets E=Expensed F=Disposal Due to Theft I=Returned to Inventory L=Like Kind Exchange M=Missing Asset N=Donated to External Group O=ARO Settlement R=Scrapped Assets S=Retirement by Sale T=Traded In for another Asset V=Auto-Retire Fully Depr Assets Y=Casualty Loss Default Value: S |
47 | RETIREMENT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Retirement Type
E=Extraordinary O=Ordinary Retirement Default Value: O |
48 | RETIREMENT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Retirement Status
C=Depreciation Calculated N=New Retirement P=Posted to General Ledger R=Reinstated Retirement U=No Retirements Exist Default Value: U |