GB_GROUP_IDBUDGET_START_DTBUDGET_IDEFFDTEFFSEQPrompt Table: ACTION_TBL
Prompt Table: ACTN_REASON_TBL
Y/N Table Edit
BUDGET_COMP_VW(SQL View) |
Index Back |
|---|---|
Budget Comparison TotalsBudget Comparison Totals |
| SELECT B.GB_GROUP_ID ,B.BUDGET_START_DT ,B.BUDGET_ID ,B.EFFDT ,B.EFFSEQ ,B.ACTION ,B.ACTION_REASON ,B.REQUESTED_AMT ,B.REQUESTED_PCT ,B.BUDGET_APPROVED ,B.BUDGET_APPROVAL_DT FROM PS_GRP_INCR_BUDGET B WHERE B.EFFDT = ( SELECT MAX(B2.EFFDT) FROM PS_GRP_INCR_BUDGET B2 WHERE B.GB_GROUP_ID = B2.GB_GROUP_ID AND B.BUDGET_START_DT = B2.BUDGET_START_DT AND B.BUDGET_ID = B2.BUDGET_ID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GB_GROUP_ID |
Character(15) | VARCHAR2(15) NOT NULL | Group Build ID. |
| 2 | BUDGET_START_DT |
Date(10) | DATE NOT NULL | Budget Period Start Date |
| 3 | BUDGET_ID |
Character(10) | VARCHAR2(10) NOT NULL | Budget ID |
| 4 | EFFDT |
Date(10) | DATE | Effective Date |
| 5 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 6 | ACTION | Character(3) | VARCHAR2(3) NOT NULL |
Action
Prompt Table: ACTION_TBL |
| 7 | ACTION_REASON | Character(3) | VARCHAR2(3) NOT NULL |
Reason Code
Prompt Table: ACTN_REASON_TBL |
| 8 | REQUESTED_AMT | Number(19,3) | DECIMAL(18,3) NOT NULL | Requested Amount |
| 9 | REQUESTED_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Requested Percent |
| 10 | BUDGET_APPROVED | Character(1) | VARCHAR2(1) NOT NULL |
Budget Approved
Y/N Table Edit |
| 11 | BUDGET_APPROVAL_DT | Date(10) | DATE | Budget Approval Date |