-
Notifications
You must be signed in to change notification settings - Fork 0
Oracle
Oracle is our clinical database. Oracle is hosted on PMACS, supports our Clinical team for integrating participant enrollment information, contact information, medications, and all tracking related to an IRB protocol study.
** This is the production server hosted by PMACS
** This server is protected and cannot be assessed without being on specific network
*** On campus: Connect to the Penn Medicine network
*** Off campus/remote: Connect to UPHS VPN using the F5/BIG-IP VPN Client
** This is the testing server hosted by PMACS
** Only designated users on the testing team are able to access this server
** This server also requires specific PMACS network
*** On campus/off campus: Connect to the PMACS VPN/Pulse Secure (http://remote.pmacs.upenn.edu)
- Development Server ** Lan's laptop- macbook pro is the development server.
There are four servers: bbldm-dev-web,bbldm-dev-db, bbldm-prd-web, and bbldm-prd-db.
Bbldm-prd-web
- Apache 2.4
- OpenJDK 1.8
- Oracle client 1.2
- Tomcat 8.5
Bbldm-prd-db
- Oracle Database Server 12C
- Service name - bbldmprd
Bbldm-dev-web
- Apache 2.4 wth self-signed TLS certificate
- OpenJDK 1.8
- Oracle client 1.2
- Tomcat 8.5
Bbldm-dev-db
- Oracle 12cR2
- SID - BBLDMDEV
Backup for Bbldm-prd-db
- RMAN runs at 1 am (cronjobs)
- Datapump runs at 10 pm (cronjobs)
Servers are backed up nightly using an industry-standard backup product (currently Commvault). The backup servers and storage are in the Pennovations datacenter on campus, offsite from all the production servers. Nightly backups are kept for at least two weeks, and longer if resources allow. Monthly backups are kept for a year, and yearly backups are kept for 5 years. Other retention policies are also in place for departments that request them.
| Date | Application | Fields | Updates |
|---|---|---|---|
| 05/01/2021 | Fullscreen | Short MRI Form | Female specific questions added (related to pregnancy and IUD) |
| 05/01/2021 | Redcap Clinical Interview | Assessment_Method,protocol_assessment | Added Assessment_Method and Dropdown, Changed varname to protocol_assessment to battery_assessment, Fixed the collateral bug |
| 05/01/2021 | Gender Identity | Gender identity Updated with following drop down options: Female, Male, Transgender woman/trans woman/male-to-female (MTF), Transgender man/trans man/female-to-male (FTM), Non-binary/Genderqueer/gender nonconforming neither exclusively male nor female, Other gender category, Decline to answer | |
| 05/21/2021 | Redcap Clinical Interview | report push | Redcap report push fail error message |
| 05/21/2021 | Redcap Clinical Interview | subject_id | Redcap fixed subject_id issues |
| 05/21/2021 | Redcap Clinical Interview | Link | link to go to redcap directly works |
| 06/04/2021 | Adaptive | Adaptive Application | Developed the adaptive application to automatically generate all links to data entry. |
| 06/04/2021 | Redcap Clinical Interview | return_id | Add Redcap return id new feature |
| 09/03/2021 | C2look | common | add common to C2look |
| 09/03/2021 | Redcap Clinical Interview | collateral | removed the rule for collateral. Now we don't check the enrollment of collateral. we can generate redcap scales for collateral |
| 09/03/2021 | Redcap Clinical Interview | pop up message | Changed the pop up message for collateral family members |
| 11/18/2021 | Demo | new app | developed a new app to collect demographic data. It doesn't need to associate with protocol |
| 11/18/2021 | subject | gender_hx | remove gender_identity, gender_hx in subject table |
| 11/18/2021 | quickscreen | gender_hx | remove gender_identity, gender_hx in quickscreen table |
| 11/24/2021 | Adaptive | Adaptive Application | use a new order in adaptive app |
| 11/24/2021 | Adaptive | links | added two links for adaptive |
| 11/30/2021 | adaptive | bug | fixed bug in adaptive link |
| 11/30/2021 | demo | mom_lname | fixed bug to get most recently mom_lname from existing demo data |
| 11/30/2021 | fulscreen_mri | bug | fixed bug in fulscreen_mri long form iup_type |
| 1/21/2021 | study visits | bug | fixed bug in study visits |
| 1/21/2021 | redcap online screen | new app | developed and released redcap online screen app |
| 2/4/2022 | fullscreen | changes | deployed fullscreen |
| 2/4/2022 | mri screen | changes | deployed mri screen |
| 3/1/2022 | online screen | more changes | deployed online screen |
| 3/1/2022 | adaptive | bugs | fixed adaptive link for battery_cat |
| 7/27/2022 | fullscreen | more changes | deployed fullscreen changes |
| 7/27/2022 | contact | more changes | contact changes, local address etc |
| 8/4/2022 | medicine | new app V1 | deployed medicine new app |
| 9/14/2022 | medicine | new app V2 | deployed medicine new app |
| OLD BBLID | NEW BBLID | DATE OF CHANGE | Notes |
|---|
In the SES section under Visit/Demos Entry, how should we report data for people who are living in dorms for college? For example, my participant yesterday was living with her parents for Winter Break but going back to the dorms for school soon. She also reported her own income although she is mainly supported by her parents.
- For the question "what best describes your current living arrangement", dorms would be counted under "in a group/boarding/rooming house". You can code this even though she is at her parents house for a short break. If she is mainly supported by her parents, you should code the "main source of personal income" as "contributions from family/spouse/partner".