PI_EARN_BAL(SQL Table) |
Index Back |
|---|---|
PI Imported Earning BalancesPayroll Interface Imported Earning Balances |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PI_RUN_NUM |
Number(4,0) | SMALLINT NOT NULL |
Payroll Interface Run Number
Prompt Table: PI_RUN_TBL |
| 2 | PI_SYSTEM_ID |
Character(4) | VARCHAR2(4) NOT NULL |
Payroll Interface System ID
Prompt Table: PI_SYSTEM_TBL |
| 3 | PI_CONFIG_ID |
Character(6) | VARCHAR2(6) NOT NULL |
PI Configuration ID
Prompt Table: PI_CONFIG_TBL |
| 4 | PI_PAY_GROUP1 |
Character(6) | VARCHAR2(6) NOT NULL | PI Paygroup 1 |
| 5 | PI_PAY_GROUP2 |
Character(6) | VARCHAR2(6) NOT NULL | PI Paygroup 2 |
| 6 | PI_EMPLID |
Character(20) | VARCHAR2(20) NOT NULL | Payroll Interface EMPLID |
| 7 | PI_BALANCE_ID |
Character(2) | VARCHAR2(2) NOT NULL | Balance ID |
| 8 | PI_BALANCE_YEAR |
Number(4,0) | SMALLINT NOT NULL | PI Balances for Year |
| 9 | PI_BALANCE_QTR |
Number(3,0) | SMALLINT NOT NULL | PI Balances for Quarter |
| 10 | PI_BALANCE_PERIOD |
Number(3,0) | SMALLINT NOT NULL | PI Balances for Period |
| 11 | CURRENCY_CD |
Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 12 | PI_EARN_TYPE |
Character(6) | VARCHAR2(6) NOT NULL | Payroll Earning Type |
| 13 | PI_EARN_CD |
Character(6) | VARCHAR2(6) NOT NULL | Payroll Earnings Code |
| 14 | HRS_YTD | Signed Number(8,2) | DECIMAL(6,2) NOT NULL | Hours YTD |
| 15 | HRS_QTD | Signed Number(8,2) | DECIMAL(6,2) NOT NULL | Hours QTD |
| 16 | HRS_MTD | Signed Number(8,2) | DECIMAL(6,2) NOT NULL | Hours Mtd |
| 17 | PI_GRS_YTD | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Gross Earnings YTD |
| 18 | PI_GRS_QTD | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Gross Earnings QTD |
| 19 | PI_GRS_MTD | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Gross Earnings MTD |
| 20 | PI_BALANCE_KEY1 | Character(10) | VARCHAR2(10) NOT NULL | User Defined Search Key 1 |
| 21 | PI_BALANCE_KEY2 | Character(10) | VARCHAR2(10) NOT NULL | User Defined Search Key 2 |