GM_PCL_SUB(SQL Table) |
Index Back |
|---|---|
Protocol Subjects |
| # | 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 | SUB_TYPE |
Character(3) | VARCHAR2(3) NOT NULL |
Subject Type
CHI=Children FET=Fetuses GEN=General OTH=Other Vulnerable PRE=Pregnant Women PRI=Prisoners |
| 5 | SUB_SOURCE | Character(30) | VARCHAR2(30) NOT NULL | Source of Subjects |
| 6 | GM_GENDER | Character(1) | VARCHAR2(1) NOT NULL |
Gender
B=Both Male/Female F=Female M=Male O=Other |
| 7 | START_DT | Date(10) | DATE | Start Date |
| 8 | END_DT | Date(10) | DATE | End Date |
| 9 | SUB_NUM | Number(5,0) | INTEGER NOT NULL | Number of Subjects |
| 10 | CNT_NUM | Number(5,0) | INTEGER NOT NULL | Number of Controls |
| 11 | YOUNGEST_AGE | Number(3,0) | SMALLINT NOT NULL | Youngest Age |
| 12 | OLDEST_AGE | Number(3,0) | SMALLINT NOT NULL | Oldest Age |
| 13 | GM_UOM_AGE_FF | Character(30) | VARCHAR2(30) NOT NULL | UOM Age - Free form text. Exampls Months , Years etc. |
| 14 | FETUS_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Require Fetuses Ex Utero
Y/N Table Edit Default Value: Y |
| 15 | DEAD_FETUS_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Require Dead Fetuses
Y/N Table Edit Default Value: N |