GL_MED_ER_VW (SQL View)	Index Back
Company Codes Use COMPANY_TBL to identify the company or companies to which you can assign employees in this database.

GL_MED_ER_VW

(SQL View)

Company Codes

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

SELECT company , effdt , GL_FICA_ER_MED FROM PS_COMPANY_TBL_GL

# 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 GL_FICA_ER_MED Character(35) VARCHAR2(35) NOT NULL U.S. GL Acct#-FICA Medicare ER

#	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	GL_FICA_ER_MED	Character(35)	VARCHAR2(35) NOT NULL	U.S. GL Acct#-FICA Medicare ER