TSE_COMPANY_TBL

index back

Company Codes

Company table used for testing TSE Edits.

PeopleSoft Field Name Field Type Column Type Description
COMPANY Character(3) VARCHAR2(3) NOT NULL Company
EFFDT Date(10) DATE NOT NULL Effective Date

Default: %date

EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default: A

DESCR Character(30) VARCHAR2(30) NOT NULL Description
DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20