GB_GROUP_IDPrompt Table: GB_GROUP_TBL
BUDGET_START_DTPrompt Table: RUN_BUDGET1_VW
BUDGET_IDN=No
Y=Yes
N=No
Y=Yes
Default Value: N
WCS_RUN_BUDGET(SQL Table) |
Index Back |
|---|---|
WCS Calaculate Budget Load |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GB_GROUP_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Group Build ID.
Prompt Table: GB_GROUP_TBL |
| 2 | BUDGET_START_DT |
Date(10) | DATE |
Budget Start Date
Prompt Table: RUN_BUDGET1_VW |
| 3 | BUDGET_ID |
Character(10) | VARCHAR2(10) NOT NULL | Budget ID |
| 4 | UPD_FUTURE_ROW_SW | Character(1) | VARCHAR2(1) NOT NULL |
Update Future Rows
N=No Y=Yes |
| 5 | SP_PROCESS_NAME | Character(12) | VARCHAR2(12) NOT NULL | Process Name |
| 6 | SUBMIT_PB | Character(1) | VARCHAR2(1) NOT NULL |
Submit
N=No Y=Yes Default Value: N |