PROJ_ADJ_101_VW(SQL View) |
Index Back |
---|---|
Adjust Resources View |
SELECT A.BUSINESS_UNIT ,A.PROJECT_ID ,A.ACTIVITY_ID ,A.RESOURCE_ID ,A.RESOURCE_ID_FROM ,A.BUSINESS_UNIT_GL ,A.JOURNAL_ID ,A.JOURNAL_DATE ,A.UNPOST_SEQ ,A.JOURNAL_LINE ,A.FISCAL_YEAR ,A.ACCOUNTING_PERIOD ,A.ACCOUNT ,A.ALTACCT , A.DEPTID ,%subrec(CF16_AN_SBR, A) ,A.STATISTICS_CODE ,B.ANALYSIS_TYPE_MAP ,B.ANALYSIS_GROUP ,A.ANALYSIS_TYPE ,A.RESOURCE_TYPE ,A.RESOURCE_CATEGORY ,A.RESOURCE_SUB_CAT ,A.TRANS_DT ,A.ACCOUNTING_DT ,A.JOURNAL_LINE_DATE ,A.PC_DISTRIB_STATUS ,A.GL_DISTRIB_STATUS ,A.DESCR ,A.UNIT_OF_MEASURE ,A.RESOURCE_QUANTITY ,A.RESOURCE_AMOUNT ,A.CURRENCY_CD FROM PS_PROJ_RESOURCE A , PS_PROJ_AN_GRP_MAP B WHERE B.ANALYSIS_TYPE = A.ANALYSIS_TYPE |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: PROJ_ACTIVITY.BUSINESS_UNIT Prompt Table: SP_BU_PC_NONVW |
2 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Default Value: PROJ_ACTIVITY.PROJECT_ID Prompt Table: PROJECT_VW |
3 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL |
Activity ID
Default Value: PROJ_ACTIVITY.ACTIVITY_ID Prompt Table: PROJ_ACTIVITY |
4 | RESOURCE_ID | Character(40) | VARCHAR2(40) NOT NULL | Transaction ID |
5 | RESOURCE_ID_FROM | Character(40) | VARCHAR2(40) NOT NULL | Original Transaction ID |
6 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL |
GL Business Unit
Prompt Table: SP_BU_GL_NONVW |
7 | JOURNAL_ID | Character(10) | VARCHAR2(10) NOT NULL | Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier. |
8 | JOURNAL_DATE | Date(10) | DATE | Specifies the date the journal was created. |
9 | UNPOST_SEQ | Number(2,0) | SMALLINT NOT NULL | Identifies the sequence of journal entries when a journal is "unposted". When a journal is posted the UnPost Sequence is automatically set to "0". When a journal is unposted, a new reversing entry is automatically created with an UnPost Sequence of "1". |
10 | JOURNAL_LINE | Number(9,0) | DECIMAL(9) NOT NULL | Uniquely identifies a journal line with a sequence number. Within a single journal entry, the line sequence begins with 1 and automatically increments by 1 for each succeeding journal line. There can be any number of lines associated with a journal header. |
11 | FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
12 | ACCOUNTING_PERIOD | Number(3,0) | SMALLINT NOT NULL | Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table. |
13 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL |
Account
Prompt Table: GL_ACCOUNT_TBL |
14 | ALTACCT | Character(10) | VARCHAR2(10) NOT NULL |
Alternate Account
Prompt Table: ALTACCT_TBL |
15 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPTID_BUGL_VW |
16 | OPERATING_UNIT | Character(8) | VARCHAR2(8) NOT NULL |
Operating Unit ChartField
Prompt Table: OPERUNT_BUGL_VW |
17 | PRODUCT | Character(6) | VARCHAR2(6) NOT NULL |
Product ChartField
Prompt Table: PRODUCT_BUGL_VW |
18 | FUND_CODE | Character(5) | VARCHAR2(5) NOT NULL |
Fund Code
Prompt Table: FUND_BUGL_VW |
19 | CLASS_FLD | Character(5) | VARCHAR2(5) NOT NULL |
Class Field
Prompt Table: CLASSCF_BUGL_VW |
20 | PROGRAM_CODE | Character(5) | VARCHAR2(5) NOT NULL |
Program Code ChartField
Prompt Table: PROGRAM_BUGL_VW |
21 | BUDGET_REF | Character(8) | VARCHAR2(8) NOT NULL |
Budget Reference
Prompt Table: BUD_REF_BUGL_VW |
22 | AFFILIATE | Character(5) | VARCHAR2(5) NOT NULL |
Affiliate
Prompt Table: AFFILIATE_VW |
23 | AFFILIATE_INTRA1 | Character(10) | VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
Prompt Table: %EDIT_INTRA01 |
24 | AFFILIATE_INTRA2 | Character(10) | VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
Prompt Table: %EDIT_INTRA02 |
25 | CHARTFIELD1 | Character(10) | VARCHAR2(10) NOT NULL |
Expansion chartfield 1
Prompt Table: CF1_BUGL_VW |
26 | CHARTFIELD2 | Character(10) | VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
Prompt Table: CF2_BUGL_VW |
27 | CHARTFIELD3 | Character(10) | VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
Prompt Table: CF3_BUGL_VW |
28 | STATISTICS_CODE | Character(3) | VARCHAR2(3) NOT NULL | Statistics Code |
29 | ANALYSIS_TYPE_MAP | Character(3) | VARCHAR2(3) NOT NULL | Analysis Type Map |
30 | ANALYSIS_GROUP | Character(5) | VARCHAR2(5) NOT NULL |
Analysis Group
Prompt Table: SP_AN_GRP_NONVW |
31 | ANALYSIS_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Analysis Type
Prompt Table: PROJ_ANTYPE_TBL |
32 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Source Type
Prompt Table: PROJ_RES_TYPE |
33 | RESOURCE_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL |
Category
Prompt Table: %EDITTABLE |
34 | RESOURCE_SUB_CAT | Character(5) | VARCHAR2(5) NOT NULL |
Subcategory
Prompt Table: %EDITTABLE2 |
35 | TRANS_DT | Date(10) | DATE |
Transaction Date
Default Value: %date |
36 | ACCOUNTING_DT | Date(10) | DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
Default Value: %date |
37 | JOURNAL_LINE_DATE | Date(10) | DATE | Specifies the date of a journal line. This date must be the same as the journal date on the header (JOURNAL_DATE) in order for the Parent/Child relationship to remain intact. |
38 | PC_DISTRIB_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
PC Distribution Status
B=Budget Check D=Distributed G=Generated H=Hold I=Ignore M=Modified N=Not Distributed S=Staged |
39 | GL_DISTRIB_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Distribution Status
C=Available to Contracts D=Distributed G=Generated H=Hold I=Ignored J=Creating Journals M=Modified N=None P=To be processed X=Waiting for Reversal |
40 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
41 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage Prompt Table: UNITS_TBL |
42 | RESOURCE_QUANTITY | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Quantity |
43 | RESOURCE_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Transaction Amount |
44 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |