COMPANY_TBL_CK

(SQL View)
 Index Back

Company Codes

Use COMPANY_TBL to identify the company or companies to which you can assign employees in this database.

SELECT A.company , A.effdt , B.federal_ein , A.GL_FWT , A.GL_FICA_EE_OASDI , A.GL_FICA_EE_MED , A.GL_FICA_ER_OASDI , A.GL_FICA_ER_MED , A.GL_FUT , A.GL_EIC , A.GL_NET_PAY , A.GL_DIR_DEPOSITS , A.GL_FICA_EXP_OASDI , A.GL_FICA_EXP_MED , A.GL_FUT_EXPENSE , A.GL_SUT_EXPENSE , A.GL_SDI_EXPENSE , A.GL_LCL_EXP FROM PS_COMPANY_TBL_GL A , PS_COMPANY_TBL B WHERE A.COMPANY = B.COMPANY AND A.EFFDT = B.EFFDT

# 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 FEDERAL_EIN Number(9,0) DECIMAL(9) NOT NULL Federal EIN
4 GL_FWT Character(35) VARCHAR2(35) NOT NULL U.S. GL Acct#-FWT
5 GL_FICA_EE_OASDI Character(35) VARCHAR2(35) NOT NULL U.S. GL Acct#-FICA OASDI EE
6 GL_FICA_EE_MED Character(35) VARCHAR2(35) NOT NULL U.S. GL Acct#-FICA Medicare EE
7 GL_FICA_ER_OASDI Character(35) VARCHAR2(35) NOT NULL U.S. GL Acct#-FICA OASDI ER
8 GL_FICA_ER_MED Character(35) VARCHAR2(35) NOT NULL U.S. GL Acct#-FICA Medicare ER
9 GL_FUT Character(35) VARCHAR2(35) NOT NULL U.S. GL Acct#-FUT
10 GL_EIC Character(35) VARCHAR2(35) NOT NULL U.S. GL Acct#-EIC
11 GL_NET_PAY Character(35) VARCHAR2(35) NOT NULL GL Acct#-Net Pay
12 GL_DIR_DEPOSITS Character(35) VARCHAR2(35) NOT NULL GL Acct#-Direct Deposits
13 GL_FICA_EXP_OASDI Character(35) VARCHAR2(35) NOT NULL U.S. GL Acct#-FICA OASDI Exp
14 GL_FICA_EXP_MED Character(35) VARCHAR2(35) NOT NULL U.S. GL Acct#-FICA Medicre Exp
15 GL_FUT_EXPENSE Character(35) VARCHAR2(35) NOT NULL U.S. GL Acct#-FUT Expense
16 GL_SUT_EXPENSE Character(35) VARCHAR2(35) NOT NULL U.S. GL Acct#-SUT Expense
17 GL_SDI_EXPENSE Character(35) VARCHAR2(35) NOT NULL U.S. GL Acct#-SDI Expense
18 GL_LCL_EXP Character(35) VARCHAR2(35) NOT NULL U.S. GL Acct#-Local Expense