• BUSINESS_ADMINISTRATOR_PENN_ID
• FOURTH_SPONSOR
• INDUSTRY_SPONS_ADDR1
• INDUSTRY_SPONS_ADDR2
• INDUSTRY_SPONS_CITY_STATE_ZIP
• INDUSTRY_SPONS_CONTACT_NAME
• INDUSTRY_SPONS_CRO_ADDR1
• INDUSTRY_SPONS_CRO_ADDR2
• INDUSTRY_SPONS_CRO_BILL
• INDUSTRY_SPONS_CRO_CITY_ST_ZIP
• INDUSTRY_SPONS_CRO_CONT_PERSON
• INDUSTRY_SPONS_CRO_EMAIL
• INDUSTRY_SPONS_CRO_FAX
• INDUSTRY_SPONS_CRO_NAME
• INDUSTRY_SPONS_CRO_PHONE
• INDUSTRY_SPONS_EMAIL
• INDUSTRY_SPONS_FAX

• INDUSTRY_SPONS_NAME
• INDUSTRY_SPONS_PHONE
• IND_SPONSOR
• PI_PENN_ID
• PRIMARY_SPONSOR
• PROJECT_FUNDED
• PROTOCOL_NUMBER
• PROTOCOL_TITLE
• REGULATORY_SPONSOR
• RESPONSIBLE_ORG
• SECOND_SPONSOR
• SHORT_TITLE
• STATUS
• SUBJECT_COMPENSATION
• SUBJECT_COMPENSATION_DETAILS
• THIRD_SPONSOR

The Penn ID of the Business Administrator (BA) of the Responsible Org for the protocol (PROTOCOL_NUMBER).

A Penn ID is an 8-digit identification number assigned to an individual by Penn Community system. For example: 77777777. No two persons have the same Penn ID. Note that Penn IDs created in and assigned by Penn Community begin at 10000000. Within the Data Warehouse, the numeric range from 00000000-00999999 is used for individuals who do not yet have a Penn ID in Penn Community, to allow for reliable joins between tables using the PENN_ID column. When a Penn ID appears for the individual appear in Penn Community, it will replace the assigned value throughout the Data Warehouse.

Further information about the Business Administrator is available in the PENNERA_PEOPLE table (in the DWADMIN schema). Note: BUSINESS_ADMINISTRATOR_PENN_ID is stored in NUMBER format, but the format for PENN_ID in PENNERA_PEOPLE is CHAR(8). The Business Objects Universes that include BUSINESS_ADMINISTRATOR_PENN_ID convert it to a character value when joining it to PENN_ID in PENNERA_PEOPLE.

The 5-character numeric code that uniquely identifies the fourth listed agency, organization, company, or person (if any) that is providing funds for the research specified in the protocol.

See also PRIMARY_SPONSOR, SECOND_SPONSOR, and THIRD_SPONSOR.

Example: '54144' (NEUROSCIENCE NURSING FOUNDATION).

Values:  Refer to the PENNERA_SPONSOR table 
(in the DWADMIN schema) for values.  

The text of the first line of the postal address of the billing source for IRB-related fees for industry sponsored research. The value is stored in mixed case.

See also INDUSTRY_SPONS_ADDR2 and INDUSTRY_SPONS_CITY_STATE_ZIP.

The text of the second line of the postal address of the billing source for IRB-related fees for industry sponsored research. The value is stored in mixed case.

See also INDUSTRY_SPONS_ADDR1 and INDUSTRY_SPONS_CITY_STATE_ZIP.

The text of the third line of the postal address of the billing source for IRB-related fees for industry sponsored research. For United States addresses, this is usually the city, state, and ZIP code. For addresses in other countries, this is usually the country and postal code. The value is stored in mixed case.

See also INDUSTRY_SPONS_ADDR1 and INDUSTRY_SPONS_ADDR2.

The name of the contact person at the billing source for IRB-related fees for industry sponsored research. The value is stored in mixed case.

Example: 'Michael Smith'

The text of the first line of the postal address of the Contract Research Organization (CRO) that is the liaison between the sponsor and participating site. The value is stored in mixed case.

See also INDUSTRY_SPONS_CRO_ADDR2 and INDUSTRY_SPONS_CRO_CITY_ST_ZIP.

The text of the second line of the postal address of the Contract Research Organization (CRO) that is the liaison between the sponsor and participating site. The value is stored in mixed case.

See also INDUSTRY_SPONS_CRO_ADDR1 and INDUSTRY_SPONS_CRO_CITY_ST_ZIP.

If there is a billing source for IRB-related fees for industry sponsored research, this indicates whether the bills are sent to the sponsor (see INDUSTRY_SPONS_NAME) or to the Contract Research Organization (CRO; see INDUSTRY_SPONS_CRO_NAME).

Values: 
 
CRO     (bills are sent to the Contract Research Organization)
SPONSOR (bills are sent to the industry sponsor)
[null]  (a billing source for IRB-related fees for industry
         sponsored research has not been specified)

The text of the third line of the postal address of the Contract Research Organization (CRO) that is the liaison between the sponsor and participating site. For United States addresses, this is usually the city, state, and ZIP code. For addresses in other countries, this is usually the country and postal code. The value is stored in mixed case.

See also INDUSTRY_SPONS_CRO_ADDR1 and INDUSTRY_SPONS_CRO_ADDR2.

The name of the contact person at the Contract Research Organization (CRO) that is the liaison between the sponsor and participating site. The value is stored in mixed case.

Example: 'Abigail King'

The e-mail address of the Contract Research Organization (CRO) that is the liaison between the sponsor and participating site. The value is stored in mixed case.

The fax number for the Contract Research Organization (CRO) that is the liaison between the sponsor and participating site.

Example: '610-650-1895'

The name of the Contract Research Organization (CRO) that is the liaison between the sponsor and participating site. The value is stored in mixed case.

See also INDUSTRY_SPONS_CRO_BILL.

The telephone number of the Contract Research Organization (CRO) that is the liaison between the sponsor and participating site.

Example: '877-650-1919'

The email address of the billing source for IRB-related fees for industry sponsored research. The value is stored in mixed case.

The fax number for the billing source for IRB-related fees for industry sponsored research.

Example: '9195444918'

The name of the billing source for IRB-related fees for industry sponsored research. The value is stored in mixed case.

See also INDUSTRY_SPONS_CRO_BILL.

The telephone number of the billing source for IRB-related fees for industry sponsored research.

Example: '7812295900'

The name of the investigator or entity that is the sponsor of the Investigational New Drug (IND) being referenced for the research specified in the protocol. The value is stored in mixed case.

The Penn ID of the Principal Investigator (PI) for the research specified in the protocol. This is not necessarily the same as the PI for the proposal(s) using this protocol.

A Penn ID is an 8-digit identification number assigned to an individual by Penn Community system. For example: 77777777. No two persons have the same Penn ID. Note that Penn IDs created in and assigned by Penn Community begin at 10000000. Within the Data Warehouse, the numeric range from 00000000-00999999 is used for individuals who do not yet have a Penn ID in Penn Community, to allow for reliable joins between tables using the PENN_ID column. When a Penn ID appears for the individual appear in Penn Community, it will replace the assigned value throughout the Data Warehouse.

Further information about the PI is available in the PENNERA_PERSON table (in the DWADMIN schema).

The 5-character numeric code that uniquely identifies the primary agency, organization, company or person that is providing funds for the research specified in the protocol.

See also SECOND_SPONSOR, THIRD_SPONSOR, and FOURTH_SPONSOR

Example: '09470' (NATIONAL INSTITUTES OF HEALTH)

Values:  Refer to the PENNERA_SPONSOR table 
(in the DWADMIN schema) for values.

Indicates whether the research specified in the protocol is funded by, or associated with, a grant or contract.

The information stored in this flag is whatever was entered by the person that submitted the protocol. A better source of information on funding is the PennERA Proposals data collection. Caution: a given protocol may be listed more than once for the same proposal in the PENNERA_PROP_REGULATORY_APPR table.

• Business Objects users will find that the PennERA Proposals and PennERA Balances Universes include a Class (folder) called HS Protocol IRB V - APPR, which facilitates looking up the protocol's funding information in the PennERA Proposals data collection.
• Other users may join the PENNERA_PROP_REGULATORY_APPR table to the PennERA Proposals table with the desired funding information, and use a join where DWADMIN.PENNERA_PROP_REGULATORY_APPR.REGULATORY_TYPE = 'Human Subjects' and DWADMIN.PENNERA_PROP_REGULATORY_APPR.REFERENCE_NO = DWSP.HS_PROTOCOL_IRB_V.PROTOCOL_NUMBER(+).

Values: 
 
F      ([false] no, the project is not funded)
P      (project funding is pending)
T      ([true] yes, the project is funded)
[null] (project funding status has not been specified)

Values are stored in DWSP.HS_PROTOCOL_LOV where 
HS_PROTOCOL_IRB_V.PROJECT_FUNDED = HS_PROTOCOL_LOV.LOV_DESC(+) 
and 'PROJECT_FUNDED' = HS_PROTOCOL_LOV.CODE_GROUP(+)

The 6-digit number that uniquely identifies the protocol for research involving human subjects, which has been submitted to the Institutional Review Board (IRB) for approval. The PROTOCOL_NUMBER is used to track the protocol in the HS-ERA system and in the Human Subjects module of the PennERA system.

A protocol describes the method or procedure for carrying out an experiment, investigation, or course of medical treatment.

See also PROTOCOL_TITLE and SHORT_TITLE.

The full title of the protocol for research involving human subjects, which has been submitted to the Institutional Review Board (IRB) for approval. The value is stored in mixed case.

A protocol describes the method or procedure for carrying out an experiment, investigation, or course of medical treatment.

See also PROTOCOL_NUMBER and SHORT_TITLE.

The 5-character numeric code that uniquely identifies the agency, organization, company, or person that is primarily responsible for initiating and overseeing the research specified in the protocol, and ensuring that the study complies with research standards and federal regulations. This is not necessarily the same as the PRIMARY_SPONSOR.

Example: '09470' (NATIONAL INSTITUTES OF HEALTH)

Values:  Refer to the PENNERA_SPONSOR table 
(in the DWADMIN schema) for values.

Example: 4261 (DM-Rheumatology)

Values:  Refer to the ORG_CODES table (in the DWADMIN schema) for values.

The 5-character numeric code that uniquely identifies the secondary agency, organization, company or person (if any) that is providing funds for the research specified in the protocol.

See also PRIMARY_SPONSOR, THIRD_SPONSOR, and FOURTH_SPONSOR.

Example: '61167' (FRANK MORGAN JONES FUND)

Values:  Refer to the PENNERA_SPONSOR table 
(in the DWADMIN schema) for values.

A brief version of the title of the protocol for research involving human subjects, which has been submitted to the Institutional Review Board (IRB). The value is stored in mixed case.

A protocol describes the method or procedure for carrying out an experiment, investigation, or course of medical treatment.

See also PROTOCOL_NUMBER and PROTOCOL_TITLE.

Indicates whether or not the protocol is approved for use. If the protocol has yet to be reviewed, the STATUS indicates where it is in the review process.

STATUS reflects the Status shown in the Approval section of protocol's Summary screen in the PennERA Human Subjects module, and the PennERA Protocol Status shown on the Basic Info tab when you view the Protocol Application Form in HS-ERA.

Values:

Accepted
Acknowledged  (The administrators have acknowledged receipt
  of the protocol.)
Acknowledged (CHOP-Penn) (The administrators have acknowledged receipt
  of the protocol. The work described in the protocol is being done
  in cooperation with the Children’s Hospital of Philadelphia.)
Administratively Finalized
Approved  (The board or committee has approved the protocol for use.) 
Approved (CHOP-Penn)  (The board or committee has approved the
  protocol for use. The work described in the protocol is being done
  in cooperation with the Children’s Hospital of Philadelphia.)
Approved Concept in Principle
Approved Contract Pending
Approved Status Withheld
Closed
Completed  (All research activity under the human protocol has ended.)
Conditional Re-approval  (The reviewers have sent the protocol 
  back to the PI for minor revisions. The protocol is active, but
  no research can be done until approval is granted.)
Disapproved  (The protocol has been reviewed, and is not approved for use.)
Expired  (The protocol has been administratively inactivated because
  its approval period has ended. No research activity is allowed to be
  conducted under the protocol until the PI files a request to have the 
  protocol reviewed, and the review is approved.)
Issue Identified
Logged  (The protocol has been received but has not yet been scheduled
  for review.)
No Continuing Review Required
Pending  (The protocol is pending review.)
Tabled  (The reviewers have sent the protocol back to the PI for major
  revisions. The protocol is not yet approved for use.)
Terminated  (All research activity under the protocol has ended.)
Withdrawn Submission  (The PI has withdrawn the protocol from consideration.)
Withheld Approval  (The reviewers have sent the protocol back to the PI for
  minor revisions. The protocol is not yet approved for use.)

Values: 
 
F      ([false] no, subjects will not be financially compensated for their 
        participation)
T      ([true] yes, subjects will be financially compensated for their)
        participation)
[null] (subject compensation has not been specified; no subjects to
        be recruited)

If subjects will be financially compensated for their participation in the research specified in the protocol, this text (in mixed case) describes the compensation that will be offered to subjects. The information should include the kind of compensation (such as cash payments, gift cards, or reimbursement for travel), the schedule for compensation per study visit or session, and the total amount for entire participation.

Note: this text is stored in a CLOB. Business Objects queries that use SUBJECT_COMPENSATION_DETAILS will access just the first 4,000 characters of the text in this data element for each record.

The 5-character numeric code that uniquely identifies the tertiary agency, organization, company or person (if any) that is providing funds for the research specified in the protocol.

See also PRIMARY_SPONSOR, SECOND_SPONSOR, and FOURTH_SPONSOR.

Example: '50398' (SIGMA THETA TAU)

Values:  Refer to the PENNERA_SPONSOR table 
(in the DWADMIN schema) for values.