WPLACE_TBL_BRA (SQL Table)	Index Back
Worplace Setup Tbl BRA Workplace setup table BRA.

WPLACE_TBL_BRA

(SQL Table)

Worplace Setup Tbl BRA

Workplace setup table BRA.

Related Language Record: WPL_TBL_BRA_LNG

Parent Record Of WPL_ES2_LNG_BRA WPL_EST2_VW_BRA WPL_ESTAB_BRA WPL_EST_LNG_BRA WPL_EST_VW_BRA WPL_SRV_LNG_BRA WPL_SRV_TKR_BRA WPL_SRV_VW_BRA WPL_THIRD_P_BRA

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 WPLACE_LOC_BRA Character(1) VARCHAR2(1) NOT NULL Worplace location.
1=Employer Establishment
2=Service Taker Establishment
3=Third Party Establishment

3 WPLACE_CODE_BRA Character(10) VARCHAR2(10) NOT NULL Workplace code.

4 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

6 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description

7 DESCRLONG Long Character CLOB NOT NULL Long Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
2	WPLACE_LOC_BRA	Character(1)	VARCHAR2(1) NOT NULL	Worplace location. 1=Employer Establishment 2=Service Taker Establishment 3=Third Party Establishment
3	WPLACE_CODE_BRA	Character(10)	VARCHAR2(10) NOT NULL	Workplace code.
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
5	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
6	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description
7	DESCRLONG	Long Character	CLOB NOT NULL	Long Description