COMPANYPrompt Table: COMPANY_TBL
PAYGROUPPrompt Table: PAYGROUP_TBL
PAY_END_DTPrompt Table: PAY_CALENDAR
BALANCE_IDPrompt Table: BALANCE_ID_TBL
Prompt Table: BALANCE_YR_VW
Prompt Table: BALANCE_ID_DEF
Prompt Table: BALANCE_ID_QTR
PAY_CAL_BAL_ID(SQL Table) |
Index Back |
|---|---|
Pay Calendar - Balance IDThis table contains a row of data for every confirmed period in the Balance_ID_Def table. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 2 | PAYGROUP |
Character(3) | VARCHAR2(3) NOT NULL |
Pay Group
Prompt Table: PAYGROUP_TBL |
| 3 | PAY_END_DT |
Date(10) | DATE NOT NULL |
Pay Period End Date
Prompt Table: PAY_CALENDAR |
| 4 | BALANCE_ID |
Character(2) | VARCHAR2(2) NOT NULL |
Balance ID
Prompt Table: BALANCE_ID_TBL |
| 5 | BALANCE_YEAR | Number(4,0) | SMALLINT NOT NULL |
Balances for Year
Prompt Table: BALANCE_YR_VW |
| 6 | BALANCE_PERIOD | Number(3,0) | SMALLINT NOT NULL |
Balances for Period
Prompt Table: BALANCE_ID_DEF |
| 7 | BALANCE_QTR | Number(3,0) | SMALLINT NOT NULL |
Balances for Quarter
Prompt Table: BALANCE_ID_QTR |