| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 2 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
STATE_TAX_TBL
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 5 |
SUT_EFF_TAX_YR |
Number(4,0) |
SMALLINT NOT NULL |
SUT Effective Tax Year.
|
| 6 |
DIS_EFF_TAX_YR |
Number(4,0) |
SMALLINT NOT NULL |
Disability Effective Tax Year.
|
| 7 |
SUT_EFF_TAX_QTR |
Character(1) |
VARCHAR2(1) NOT NULL |
SUT Effective Tax Quarter.
1=First Quarter
2=Second Quarter
3=Third Quarter
4=Fourth Quarter
|
| 8 |
DIS_EFF_TAX_QTR |
Character(1) |
VARCHAR2(1) NOT NULL |
Disability Effective Tax Quarter.
1=First Quarter
2=Second Quarter
3=Third Quarter
4=Fourth Quarter
|
| 9 |
BRANCH_CD |
Number(2,0) |
SMALLINT NOT NULL |
Branch Code.
|
| 10 |
EXEMPT_SUT |
Character(1) |
VARCHAR2(1) NOT NULL |
Exempt From SUT.
Y/N Table Edit
Default Value: N
|
| 11 |
EXEMPT_DIS |
Character(1) |
VARCHAR2(1) NOT NULL |
Exempt From ER Disability.
Y/N Table Edit
Default Value: N
|
| 12 |
EMPLOYER_ID_SWT |
Character(20) |
VARCHAR2(20) NOT NULL |
Employer ID (SWT).
|
| 13 |
EMPLOYER_ID_SUT |
Character(20) |
VARCHAR2(20) NOT NULL |
Employer ID (SUT).
|
| 14 |
SUT_EXPERIENCE_RT |
Number(8,5) |
DECIMAL(7,5) NOT NULL |
SUT Experience Rate.
|
| 15 |
DIS_EXPERIENCE_RT |
Number(8,5) |
DECIMAL(7,5) NOT NULL |
Disability Experience Rate.
|
| 16 |
GL_SWT |
Character(35) |
VARCHAR2(35) NOT NULL |
GL Account #-SWT.
Prompt Table:
GL_ACCOUNT_VW
|
| 17 |
GL_SUT |
Character(35) |
VARCHAR2(35) NOT NULL |
GL Account #-SUT.
Prompt Table:
GL_ACCOUNT_VW
|
| 18 |
GL_SDI |
Character(35) |
VARCHAR2(35) NOT NULL |
GL Account #-SDI.
Prompt Table:
GL_ACCOUNT_VW
|
| 19 |
GL_SUT_ER |
Character(35) |
VARCHAR2(35) NOT NULL |
GL-SUT (Employer).
Prompt Table:
GL_ACCOUNT_VW
|
| 20 |
GL_SDI_ER |
Character(35) |
VARCHAR2(35) NOT NULL |
GL-SDI (Employer).
Prompt Table:
GL_ACCOUNT_VW
|
| 21 |
SHI_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
State Health Insurance Override.
Y/N Table Edit
Default Value: N
|
| 22 |
SHI_RATE |
Signed Number(8,6) |
DECIMAL(6,6) NOT NULL |
State Health Insurance Override Rate.
|
| 23 |
NON_RES_DECLR_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Non-Resident Declaration Request.
Y/N Table Edit
Default Value: N
|
| 24 |
VDI_PLAN |
Character(1) |
VARCHAR2(1) NOT NULL |
Voluntary Disability Plan.
Y/N Table Edit
Default Value: N
|
| 25 |
VDI_PLAN_NBR |
Character(10) |
VARCHAR2(10) NOT NULL |
VDI Plan Number.
|
| 26 |
VDI_ADMIN_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
VDI/FLI Administrator Code
Prompt Table:
VDI_ADMIN_TBL
|
| 27 |
GL_VDI_EE |
Character(35) |
VARCHAR2(35) NOT NULL |
GL Account #- VDI/EE.
Prompt Table:
GL_ACCOUNT_VW
|
| 28 |
GL_VDI_ER |
Character(35) |
VARCHAR2(35) NOT NULL |
GL Account #-VDI/ER.
Prompt Table:
GL_ACCOUNT_VW
|
| 29 |
VDI_EFF_TAX_YR |
Number(4,0) |
SMALLINT NOT NULL |
VDI Effective Tax Year.
|
| 30 |
VDI_EFF_TAX_QTR |
Character(1) |
VARCHAR2(1) NOT NULL |
VDI Effective Tax Quarter.
1=First Quarter
2=Second Quarter
3=Third Quarter
4=Fourth Quarter
|
| 31 |
VDI_EE_RT |
Number(8,5) |
DECIMAL(7,5) NOT NULL |
VDI Experience Rate EE
|
| 32 |
VDI_ER_RT |
Number(8,5) |
DECIMAL(7,5) NOT NULL |
VDI Experience Rate ER
|
| 33 |
EMPLOYER_ID_DIS |
Character(20) |
VARCHAR2(20) NOT NULL |
Employer ID (DIS).
|
| 34 |
GL_ST_EIC |
Character(35) |
VARCHAR2(35) NOT NULL |
State GL Acct#-EIC
Prompt Table:
GL_ACCOUNT_VW
|
| 35 |
UBI_NUMBER |
Number(12,0) |
DECIMAL(12) NOT NULL |
Unified Business ID Number
|
| 36 |
EAF_RATE |
Number(8,5) |
DECIMAL(7,5) NOT NULL |
Employment Administration Fund Rate
|
| 37 |
HEALTH_CARE_COV |
Character(1) |
VARCHAR2(1) NOT NULL |
Health Care Coverage
Y/N Table Edit
Default Value: N
|
| 38 |
PNA_FLI_ADMIN_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
FLI Administrator Code
Prompt Table:
VDI_ADMIN_TBL
|
| 39 |
PNA_EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
|
| 40 |
PNA_FLI_EFF_TAX_YR |
Number(4,0) |
SMALLINT NOT NULL |
FLI Effective Tax Year
|
| 41 |
PNA_FLI_EFF_TX_QTR |
Character(1) |
VARCHAR2(1) NOT NULL |
FLI Effective Tax Quarter
1=First Quarter
2=Second Quarter
3=Third Quarter
4=Fourth Quarter
|
| 42 |
PNA_FLI_PLAN |
Character(1) |
VARCHAR2(1) NOT NULL |
Voluntary Family Leave Plan
Y/N Table Edit
Default Value: N
|
| 43 |
PNA_FLI_PLAN_NBR |
Character(10) |
VARCHAR2(10) NOT NULL |
FLI Plan Number
|
| 44 |
PNA_FLI_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
FLI Status
E=Exempt
N=Not Applicable
V=Voluntary Plan
Y=Subject
|
| 45 |
PNA_FLI_EE_RT |
Number(8,5) |
DECIMAL(7,5) NOT NULL |
FLI Experience Rate EE
|
| 46 |
PNA_FLI_ER_RT |
Number(8,5) |
DECIMAL(7,5) NOT NULL |
FLI Experience Rate ER
|
| 47 |
PNA_GL_FLI_EE |
Character(35) |
VARCHAR2(35) NOT NULL |
GL Account # - FLI
Prompt Table:
GL_ACCOUNT_VW
|
| 48 |
PNA_GL_VFLI_EE |
Character(35) |
VARCHAR2(35) NOT NULL |
GL Account # - VFLI
Prompt Table:
GL_ACCOUNT_VW
|
| 49 |
PNA_GL_VFLI_ER |
Character(35) |
VARCHAR2(35) NOT NULL |
GL Account # - VFLI
Prompt Table:
GL_ACCOUNT_VW
|
| 50 |
SUI_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
State UI Override
Y/N Table Edit
Default Value: N
|
| 51 |
SUI_MAX_GROSS |
Number(8,0) |
INTEGER NOT NULL |
UI taxable wage base
|