PeopleSoft 9
Asset Management

Table Name AGENCY_TBL

Table Description
AGENCY_TBL
Columns
Name Datatype Is PK Is FK
SETID char(5) Yes No
AGENCY_ID char(20) Yes No
EFFDT PSDATE Yes No
EFF_STATUS char(1) No No
AGENCY_NAME char(30) No No
AGENCY_TYPE char(3) No No
CONTACT_NAME char(50) No No
ADDRESS1 char(55) No No
PHONE_NUM char(12) No No
FAX char(24) No No
COMMENTS TEXT No No
Index
Name Type Unique Member
PS_AGENCY_TBL PK Yes
Member(s) of "PS_AGENCY_TBL" Index
SETID
AGENCY_ID
EFFDT

Published December 16, 2006