GM_PCL_PROC(SQL Table) |
Index Back |
|---|---|
Protocol Proceedures |
| # | 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 |
| 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 | TITLE56 | Character(56) | VARCHAR2(56) NOT NULL | TITLE56 |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | GM_PCL_EUTH_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Euthanasia/Disposition Method
Y/N Table Edit |
| 8 | GM_PCL_EUTH | Character(100) | VARCHAR2(100) NOT NULL | Euthanasia /Disposition Method |
| 9 | GM_HAZ_AGENT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Hazaradous Agents
Y/N Table Edit |
| 10 | AGENT_ID | Character(5) | VARCHAR2(5) NOT NULL |
Agent Id. Used in Grants Protocol Setup
Prompt Table: GM_PCL_AGENT |
| 11 | AA_ID | Character(5) | VARCHAR2(5) NOT NULL |
Approving Authority. Used in Grants Protocol Setup
Prompt Table: GM_PCL_APAU |
| 12 | HA_DCSN | Character(1) | VARCHAR2(1) NOT NULL |
Protocols -- Decision
A=Approved P=Pending U=Unapproved |
| 13 | HA_DCSN_DT | Date(10) | DATE | Decsion Date |
| 14 | SUB_DT | Date(10) | DATE | Submit Date |
| 15 | TRACKING_NBR | Character(30) | VARCHAR2(30) NOT NULL | Tracking Number |
| 16 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 17 | FDA_APP_REQ | Character(1) | VARCHAR2(1) NOT NULL |
FDA Approval Required
Y/N Table Edit |
| 18 | FDA_DCSN | Character(1) | VARCHAR2(1) NOT NULL |
FDA -- Decision
A=Approved P=Pending U=Unapproved |
| 19 | IND_NBR | Character(30) | VARCHAR2(30) NOT NULL | FDA IND Number. |
| 20 | FDA_DCSN_DT | Date(10) | DATE | Decision Date |
| 21 | FDA_SUB_DT | Date(10) | DATE | Submit Date |
| 22 | FDA_APP_NUM | Number(10,0) | DECIMAL(10) NOT NULL | FDA Approval Number |
| 23 | FDA_APP_DT | Date(10) | DATE | FDA Approval date |
| 24 | DESCR254_1 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 25 | FDA_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
FDA Type
IDE=IDE IND=IND |
| 26 | ADD_CARE_NEED | Character(1) | VARCHAR2(1) NOT NULL |
Additional Care Needed
Y/N Table Edit |
| 27 | ADD_CARE_DESCR | Character(254) | VARCHAR2(254) NOT NULL | Description |
| 28 | OTHR_DTL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Other Details Flag
Y/N Table Edit |
| 29 | GM_PROC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Procedures
Y/N Table Edit |
| 30 | GM_UN_PROC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Unusual Procedures
Y/N Table Edit |
| 31 | GM_ALT_PROC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Alternate Procedures
Y/N Table Edit |
| 32 | PCL_ALT_PROC | Character(100) | VARCHAR2(100) NOT NULL | Alternate Procedures |
| 33 | PCL_PROC | Character(100) | VARCHAR2(100) NOT NULL | Procedure |
| 34 | PCL_UN_PROC | Character(100) | VARCHAR2(100) NOT NULL | Unusual Procedure |