PRJ_RES_BAL_VW1(SQL View) |
Index Back |
---|---|
View of PS_PC_TLB_BAL_TAOPS_PC_TLB_BAL_TAO |
SELECT PROCESS_INSTANCE , BUSINESS_UNIT , PROJECT_ID , ACTIVITY_ID , EMPLID , EMPL_RCD , TRANS_DT , RESOURCE_TYPE , RESOURCE_CATEGORY , RESOURCE_SUB_CAT , ANALYSIS_TYPE , SUM(RESOURCE_QUANTITY) AS RESOURCE_QUANTITY , SUM(RESOURCE_AMOUNT) AS RESOURCE_AMOUNT , SUM(FOREIGN_AMOUNT) AS FOREIGN_AMOUNT FROM PS_PC_TLB_BAL_TAO WHERE PC_DISTRIB_STATUS <> 'X' GROUP BY PROCESS_INSTANCE, BUSINESS_UNIT, PROJECT_ID, ACTIVITY_ID, EMPLID, EMPL_RCD, TRANS_DT, RESOURCE_TYPE, RESOURCE_CATEGORY, RESOURCE_SUB_CAT, ANALYSIS_TYPE |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_PC_NONVW |
3 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table: PROJ_SCRTY_SRCH |
4 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table: PROJ_ACT_SRCH |
5 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
6 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
7 | TRANS_DT | Date(10) | DATE | Transaction Date |
8 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Source Type
Prompt Table: PROJ_RES_TYPE |
9 | RESOURCE_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL |
Category
Prompt Table: %EDITTABLE |
10 | RESOURCE_SUB_CAT | Character(5) | VARCHAR2(5) NOT NULL |
Subcategory
Prompt Table: %EDITTABLE2 |
11 | ANALYSIS_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Analysis Type |
12 | RESOURCE_QUANTITY | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Quantity |
13 | RESOURCE_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Transaction Amount |
14 | FOREIGN_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item. |