GM_PCL_ANM(SQL Table) |
Index Back |
|---|---|
Protocol Animals |
| # | 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
Default Value: 1 |
| 5 | GM_PD | Character(15) | VARCHAR2(15) NOT NULL | Grants Protocol Period Name . |
| 6 | GEN_CODE | Character(5) | VARCHAR2(5) NOT NULL |
Genus Code. Used in Grants Protocol Setup
Prompt Table: GM_PCL_GENUS |
| 7 | SPS_CODE | Character(5) | VARCHAR2(5) NOT NULL |
Species Code. Used in Grants Protocol Setup
Prompt Table: GM_PCL_SPECIES |
| 8 | COM_NAME | Character(30) | VARCHAR2(30) NOT NULL | Common Name. Used in Grants Protocol |
| 9 | GM_AGE | Number(3,0) | SMALLINT NOT NULL | Age |
| 10 | GM_UOM_AGE | Character(1) | VARCHAR2(1) NOT NULL |
Unit of Measure for Age.
D=Days M=Months Y=Years |
| 11 | GM_WHT | Number(5,0) | INTEGER NOT NULL | Weight |
| 12 | GM_UOM_WHT | Character(2) | VARCHAR2(2) NOT NULL |
Unit of Measure for Weight
KG=Kilograms LB=Pounds MG=Milligrams OZ=Ounces |
| 13 | GM_GENDER | Character(1) | VARCHAR2(1) NOT NULL |
Gender
B=Both Male/Female F=Female M=Male O=Other |
| 14 | NUMBER_OF_ANIMALS | Number(5,0) | INTEGER NOT NULL | NUMBER_OF_ANIMALS |
| 15 | USDA_CLASS | Character(3) | VARCHAR2(3) NOT NULL |
USDA Classification
B=B C=C D=D E=E |
| 16 | GM_AGENT_NAME | Character(40) | VARCHAR2(40) NOT NULL | Agent Name |
| 17 | GM_DOSAGE | Character(40) | VARCHAR2(40) NOT NULL | Grants Dosage for Protocols |
| 18 | GM_ROUTE_SCH | Character(40) | VARCHAR2(40) NOT NULL | Grants Dosage for Protocols |
| 19 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 20 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |