COMPANY_TBL(SQL Table) |
Index Back |
|---|---|
CompaniesCompanies |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 6 | STREET1 | Character(30) | VARCHAR2(30) NOT NULL | Street (Line 1) |
| 7 | STREET2 | Character(30) | VARCHAR2(30) NOT NULL | Street (Line 2) |
| 8 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 9 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: STATE_TBL |
| 10 | ZIP | Character(10) | VARCHAR2(10) NOT NULL | Postal Code |
| 11 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Default Value: INSTALLATION.COUNTRY Prompt Table: COUNTRY_TBL |
| 12 | FEDERAL_EIN | Number(9,0) | DECIMAL(9) NOT NULL | Federal EIN |
| 13 | FICA_STATUS_EE | Character(1) | VARCHAR2(1) NOT NULL |
FICA Status-Employee
E=Exempt M=Medicare only N=Subject Default Value: N |
| 14 | FICA_STATUS_ER | Character(1) | VARCHAR2(1) NOT NULL |
FICA Status-Employer
Default Value: N |
| 15 | FUT_EXEMPT | Character(1) | VARCHAR2(1) NOT NULL |
Exempt from FUT
Y/N Table Edit Default Value: N |
| 16 | SUT_EXEMPT | Character(1) | VARCHAR2(1) NOT NULL |
Exempt From SUT
Y/N Table Edit Default Value: N |
| 17 | SDI_EXEMPT | Character(1) | VARCHAR2(1) NOT NULL |
Employees' SDI Status
E=Exempt Y=Subject Default Value: Y |
| 18 | GL_FWT | Character(35) | VARCHAR2(35) NOT NULL | U.S. GL Acct#-FWT |
| 19 | GL_FICA_EE_OASDI | Character(35) | VARCHAR2(35) NOT NULL | U.S. GL Acct#-FICA OASDI EE |
| 20 | GL_FICA_EE_MED | Character(35) | VARCHAR2(35) NOT NULL | U.S. GL Acct#-FICA Medicare EE |
| 21 | GL_FICA_ER_OASDI | Character(35) | VARCHAR2(35) NOT NULL | U.S. GL Acct#-FICA OASDI ER |
| 22 | GL_FICA_ER_MED | Character(35) | VARCHAR2(35) NOT NULL | U.S. GL Acct#-FICA Medicare ER |
| 23 | GL_FUT | Character(35) | VARCHAR2(35) NOT NULL | U.S. GL Acct#-FUT |
| 24 | GL_EIC | Character(35) | VARCHAR2(35) NOT NULL | U.S. GL Acct#-EIC |
| 25 | GL_NET_PAY | Character(35) | VARCHAR2(35) NOT NULL | GL Acct#-Net Pay |
| 26 | GL_DIR_DEPOSITS | Character(35) | VARCHAR2(35) NOT NULL | GL Acct#-Direct Deposits |
| 27 | GL_FICA_EXP_OASDI | Character(35) | VARCHAR2(35) NOT NULL | U.S. GL Acct#-FICA OASDI Exp |
| 28 | GL_FICA_EXP_MED | Character(35) | VARCHAR2(35) NOT NULL | U.S. GL Acct#-FICA Medicre Exp |
| 29 | GL_FUT_EXPENSE | Character(35) | VARCHAR2(35) NOT NULL | U.S. GL Acct#-FUT Expense |
| 30 | GL_SUT_EXPENSE | Character(35) | VARCHAR2(35) NOT NULL | U.S. GL Acct#-SUT Expense |
| 31 | PAYGROUP | Character(3) | VARCHAR2(3) NOT NULL | Pay Group |
| 32 | DFLT_ERN_PROGRAM | Character(3) | VARCHAR2(3) NOT NULL | Default Earnings Program |
| 33 | TERMEE_PR_STOPDAYS | Number(2,0) | SMALLINT NOT NULL |
Term. EEs - PR Activity Days
Default Value: 30 |
| 34 | PAYSHEET_LINES | Number(3,0) | SMALLINT NOT NULL |
Lines on Paysheet
Default Value: 15 |
| 35 | TAX_REPORT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Tax Report Type
2=W-2 N=None R=1099R Default Value: 2 |
| 36 | COMMON_PAY_ID | Character(3) | VARCHAR2(3) NOT NULL | Common Paymaster ID |
| 37 | DED_PRIORITY_FED | Number(3,0) | SMALLINT NOT NULL |
Federal Tax Deduction Priority
Default Value: 100 |
| 38 | DED_PRIORITY_STATE | Number(3,0) | SMALLINT NOT NULL |
State Tax Deduction Priority
Default Value: 110 |