BUSINESS_UNITPROJECT_IDPC_BUDGET_IDDATETIME_STAMPACTIVITY_IDBUDGET_PERIODPrompt Table: PC_BUD_BP_DVW
PC_BUDHS_PER_VW(SQL View) |
Index Back |
|---|---|
Project Budget Detail RecordTable holding project budget amount information. Additional project budget plan information is stored in PC_BUD_PLAN. |
| SELECT DISTINCT A.BUSINESS_UNIT , A.PROJECT_ID , A.PC_BUDGET_ID , A.DATETIME_STAMP , A.ACTIVITY_ID , A.BUDGET_PERIOD FROM PS_PC_BUD_DTL_HIST A |
| # | 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 | PC_BUDGET_ID |
Number(3,0) | SMALLINT NOT NULL | Budget Plan ID |
| 4 | DATETIME_STAMP |
DateTime(26) | TIMESTAMP | DateTime Stamp |
| 5 | ACTIVITY_ID |
Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 6 | BUDGET_PERIOD |
Character(8) | VARCHAR2(8) NOT NULL |
Budget Period
Prompt Table: PC_BUD_BP_DVW |