CO_UI_RPTCD_TBL (SQL Table)	Index Back
Company UI Report Codes This record is used to store state-assigned codes used for unit or location reporting of unemployment wages. The data is keyed by company and location to accomodate situations where an organization has employees assigned to multiple companies at a single physical location.

CO_UI_RPTCD_TBL

(SQL Table)

Company UI Report Codes

This record is used to store state-assigned codes used for unit or location reporting of unemployment wages. The data is keyed by company and location to accomodate situations where an organization has employees assigned to multiple companies at a single physical location.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Prompt Table: COMPANY_TBL

2 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
Prompt Table: TAX_LOCATION1

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 UI_RPT_CODE Character(9) VARCHAR2(9) NOT NULL UI Reporting Code

6 EMPLOYER_ID_EXT Character(5) VARCHAR2(5) NOT NULL Employer ID Extension

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
2	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code Prompt Table: TAX_LOCATION1
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	UI_RPT_CODE	Character(9)	VARCHAR2(9) NOT NULL	UI Reporting Code
6	EMPLOYER_ID_EXT	Character(5)	VARCHAR2(5) NOT NULL	Employer ID Extension