GM_PCL_ANM_FACL

(SQL Table)
Index Back

Protocol Anm Facilities/Care

Protocol Animal Facilities and Care

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: GM_PCL_VRSN.BUSINESS_UNIT

Prompt Table: SP_BU_PC_NONVW

2 PCL_ID Character(15) VARCHAR2(15) NOT NULL PCL_ID
3 PCL_VRSN_ID Character(7) VARCHAR2(7) NOT NULL PCL_VRSN_ID
4 SEQNBR Number(5,0) INTEGER NOT NULL Sequence Number
5 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number

Default Value: 1

6 FACILITY_NAME Character(10) VARCHAR2(10) NOT NULL Facility Name
7 FAC_CORD_ID Character(11) VARCHAR2(11) NOT NULL Facility Coordinator Id

Prompt Table: PERSONAL_DATA

8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
9 PCL_MED_CARE Long Character CLOB Grants Protocol - Animal Medical care