| Application File.PK_APPL_FILE |
| Entity Name | Application File |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Application File.PK_APPL_FILE Index Columns |
| ColumnName | Sort Order |
| Application File Identifier |
| Application File.PK_APPL_FILE Bound Attachments |
| Name | Current Value |
| Application Message.PK_APPL_MSG |
| Entity Name | Application Message |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Application Message.PK_APPL_MSG Index Columns |
| ColumnName | Sort Order |
| MSG_ID |
| Application Message.PK_APPL_MSG Bound Attachments |
| Name | Current Value |
| Basic Energy Science Research Area.PK_BES_RSCH_AREA |
| Entity Name | Basic Energy Science Research Area |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Basic Energy Science Research Area.PK_BES_RSCH_AREA Index Columns |
| ColumnName | Sort Order |
| Research Area Identifier |
| Basic Energy Science Research Area.PK_BES_RSCH_AREA Bound Attachments |
| Name | Current Value |
| Beam Allocation Committee Allocation History.PK_BAC_ALLOC_HIST |
| Entity Name | Beam Allocation Committee Allocation History |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Beam Allocation Committee Allocation History.PK_BAC_ALLOC_HIST Index Columns |
| ColumnName | Sort Order |
| Current Date | |
| Instrument Identifier | |
| Proposal Identifier | |
| Submission Number |
| Beam Allocation Committee Allocation History.PK_BAC_ALLOC_HIST Bound Attachments |
| Name | Current Value |
| Country.PK_CNTRY |
| Entity Name | Country |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Country.PK_CNTRY Index Columns |
| ColumnName | Sort Order |
| Country Identifier |
| Country.PK_CNTRY Bound Attachments |
| Name | Current Value |
| Discretionary Review Status.PK_DISCRET_REV_STAT |
| Entity Name | Discretionary Review Status |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Discretionary Review Status.PK_DISCRET_REV_STAT Index Columns |
| ColumnName | Sort Order |
| Status Identifier |
| Discretionary Review Status.PK_DISCRET_REV_STAT Bound Attachments |
| Name | Current Value |
| Discretionary Time Category.PK_DISCRET_TIME_CAT |
| Entity Name | Discretionary Time Category |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Discretionary Time Category.PK_DISCRET_TIME_CAT Index Columns |
| ColumnName | Sort Order |
| Discretionary Time Category Identifier |
| Discretionary Time Category.PK_DISCRET_TIME_CAT Bound Attachments |
| Name | Current Value |
| Discretionary TIme Review.PK_DISCRET_TIME_REV |
| Entity Name | Discretionary TIme Review |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Discretionary TIme Review.PK_DISCRET_TIME_REV Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier | |
| Submission Number | |
| Instrument Identifier |
| Discretionary TIme Review.PK_DISCRET_TIME_REV Bound Attachments |
| Name | Current Value |
| Employee.PK_EMPLOYEE |
| Entity Name | Employee |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Employee.PK_EMPLOYEE Index Columns |
| ColumnName | Sort Order |
| Badge Number |
| Employee.PK_EMPLOYEE Bound Attachments |
| Name | Current Value |
| Experiment Facility.PK_EXPT_FACIL |
| Entity Name | Experiment Facility |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Experiment Facility.PK_EXPT_FACIL Index Columns |
| ColumnName | Sort Order |
| Facility Identifier |
| Experiment Facility.PK_EXPT_FACIL Bound Attachments |
| Name | Current Value |
| Experiment Instrument Team Safety Review.PK_EXPT_INSTR_TM_SFTY_REV |
| Entity Name | Experiment Instrument Team Safety Review |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Experiment Instrument Team Safety Review.PK_EXPT_INSTR_TM_SFTY_REV Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier | |
| Submission Number | |
| Instrument Identifier | |
| Run Number | |
| Bn |
| Experiment Instrument Team Safety Review.PK_EXPT_INSTR_TM_SFTY_REV Bound Attachments |
| Name | Current Value |
| Experiment Resource Schedule.PK_EXPT_RSRC_SCHED |
| Entity Name | Experiment Resource Schedule |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Experiment Resource Schedule.PK_EXPT_RSRC_SCHED Index Columns |
| ColumnName | Sort Order |
| Experiment Resource Identifier |
| Experiment Resource Schedule.PK_EXPT_RSRC_SCHED Bound Attachments |
| Name | Current Value |
| Experiment Safety Summary Signature Role.PK_ESS_SIGN_ROLE |
| Entity Name | Experiment Safety Summary Signature Role |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Experiment Safety Summary Signature Role.PK_ESS_SIGN_ROLE Index Columns |
| ColumnName | Sort Order |
| Role Identifier |
| Experiment Safety Summary Signature Role.PK_ESS_SIGN_ROLE Bound Attachments |
| Name | Current Value |
| Experiment Sample.PK_EXPT_SMPL |
| Entity Name | Experiment Sample |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Experiment Sample.PK_EXPT_SMPL Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier | |
| Submission Number | |
| Sample Identifier |
| Experiment Sample.PK_EXPT_SMPL Bound Attachments |
| Name | Current Value |
| Experiment Sample.EXPT_SMPL_IND1 |
| Entity Name | Experiment Sample |
| Logical Only | NO |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| Key Type | Inversion Entry |
| Experiment Sample.EXPT_SMPL_IND1 Index Columns |
| ColumnName | Sort Order |
| Approve Identifer |
| Experiment Sample.EXPT_SMPL_IND1 Bound Attachments |
| Name | Current Value |
| Experiment Sample Approval Code.PK_EXPT_SMPL_APPR_CODE |
| Entity Name | Experiment Sample Approval Code |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Experiment Sample Approval Code.PK_EXPT_SMPL_APPR_CODE Index Columns |
| ColumnName | Sort Order |
| Approve Identifer |
| Experiment Sample Approval Code.PK_EXPT_SMPL_APPR_CODE Bound Attachments |
| Name | Current Value |
| Experiment Sample Environment.PK_EXPT_SMPL_ENV |
| Entity Name | Experiment Sample Environment |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Experiment Sample Environment.PK_EXPT_SMPL_ENV Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier | |
| Submission Number |
| Experiment Sample Environment.PK_EXPT_SMPL_ENV Bound Attachments |
| Name | Current Value |
| Experiment Sample Form Association.PK_EXPT_SMPL_FORM_ASSC |
| Entity Name | Experiment Sample Form Association |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Experiment Sample Form Association.PK_EXPT_SMPL_FORM_ASSC Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier | |
| Submission Number | |
| Sample Identifier | |
| Sample Form Identifier |
| Experiment Sample Form Association.PK_EXPT_SMPL_FORM_ASSC Bound Attachments |
| Name | Current Value |
| Experiment Sample Hazard Association.PK_EXPT_SMPL_HAZ_ASSC |
| Entity Name | Experiment Sample Hazard Association |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Experiment Sample Hazard Association.PK_EXPT_SMPL_HAZ_ASSC Index Columns |
| ColumnName | Sort Order |
| Sample Identifier | |
| SMPL_HAZ_ID | |
| Proposal Identifier | |
| Submission Number |
| Experiment Sample Hazard Association.PK_EXPT_SMPL_HAZ_ASSC Bound Attachments |
| Name | Current Value |
| Experiment Sample History.PK_EXPT_SMPL_HIST |
| Entity Name | Experiment Sample History |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Experiment Sample History.PK_EXPT_SMPL_HIST Index Columns |
| ColumnName | Sort Order |
| PRPSL_ID | |
| SMPL_ID | |
| Current Date |
| Experiment Sample History.PK_EXPT_SMPL_HIST Bound Attachments |
| Name | Current Value |
| Experiment Sample History.FK_EXPT_SMPL_HIST_TO_EXPT_SMPL |
| Entity Name | Experiment Sample History |
| Logical Only | NO |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| Key Type | Inversion Entry |
| Experiment Sample History.FK_EXPT_SMPL_HIST_TO_EXPT_SMPL Index Columns |
| ColumnName | Sort Order |
| PRPSL_ID | |
| SMPL_ID |
| Experiment Sample History.FK_EXPT_SMPL_HIST_TO_EXPT_SMPL Bound Attachments |
| Name | Current Value |
| Experiment Sample Instrument Association.PK_EXPT_SMPL_INSTR_ASSC |
| Entity Name | Experiment Sample Instrument Association |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Experiment Sample Instrument Association.PK_EXPT_SMPL_INSTR_ASSC Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier | |
| Submission Number | |
| Sample Identifier | |
| Instrument Identifier |
| Experiment Sample Instrument Association.PK_EXPT_SMPL_INSTR_ASSC Bound Attachments |
| Name | Current Value |
| Experiment Sample Sample Condition Association.PK_EXPT_SMPL_SMPL_COND_ASSC |
| Entity Name | Experiment Sample Sample Condition Association |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Experiment Sample Sample Condition Association.PK_EXPT_SMPL_SMPL_COND_ASSC Index Columns |
| ColumnName | Sort Order |
| Sample Identifier | |
| SMPL_ENV_ID | |
| SMPL_COND_ID | |
| Proposal Identifier | |
| Submission Number |
| Experiment Sample Sample Condition Association.PK_EXPT_SMPL_SMPL_COND_ASSC Bound Attachments |
| Name | Current Value |
| Experiment Sample Sample Environment Association.PK_EXPT_SMPL_SMPL_ENV_ASSC |
| Entity Name | Experiment Sample Sample Environment Association |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Experiment Sample Sample Environment Association.PK_EXPT_SMPL_SMPL_ENV_ASSC Index Columns |
| ColumnName | Sort Order |
| Sample Identifier | |
| SMPL_ENV_ID | |
| Proposal Identifier | |
| Submission Number |
| Experiment Sample Sample Environment Association.PK_EXPT_SMPL_SMPL_ENV_ASSC Bound Attachments |
| Name | Current Value |
| Experiment Sample Sample Safety Association.PK_EXPT_SMPL_SMPL_SAFE_ASSC |
| Entity Name | Experiment Sample Sample Safety Association |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Experiment Sample Sample Safety Association.PK_EXPT_SMPL_SMPL_SAFE_ASSC Index Columns |
| ColumnName | Sort Order |
| Sample Identifier | |
| SMPL_SAFE_ID | |
| Proposal Identifier | |
| Submission Number |
| Experiment Sample Sample Safety Association.PK_EXPT_SMPL_SMPL_SAFE_ASSC Bound Attachments |
| Name | Current Value |
| Experiment Sample Special Requirement Association.PK_EXPT_SMPL_SPEC_REQ_ASSC |
| Entity Name | Experiment Sample Special Requirement Association |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Experiment Sample Special Requirement Association.PK_EXPT_SMPL_SPEC_REQ_ASSC Index Columns |
| ColumnName | Sort Order |
| Sample Identifier | |
| Requirement Identifier | |
| Proposal Identifier | |
| Submission Number |
| Experiment Sample Special Requirement Association.PK_EXPT_SMPL_SPEC_REQ_ASSC Bound Attachments |
| Name | Current Value |
| Experiment Schedule.PK_EXPT_SCHED |
| Entity Name | Experiment Schedule |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Experiment Schedule.PK_EXPT_SCHED Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier | |
| Submission Number | |
| Instrument Identifier | |
| Run Number |
| Experiment Schedule.PK_EXPT_SCHED Bound Attachments |
| Name | Current Value |
| Feasibility Review Category.PK_FEAS_REV_CAT |
| Entity Name | Feasibility Review Category |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Feasibility Review Category.PK_FEAS_REV_CAT Index Columns |
| ColumnName | Sort Order |
| Feasibility Review Category Identifier |
| Feasibility Review Category.PK_FEAS_REV_CAT Bound Attachments |
| Name | Current Value |
| Feasibility Review Status.PK_FEAS_REVIEW_STAT |
| Entity Name | Feasibility Review Status |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Feasibility Review Status.PK_FEAS_REVIEW_STAT Index Columns |
| ColumnName | Sort Order |
| Feasibility Review Category Identifier | |
| Feasibility Review Status Identifier |
| Feasibility Review Status.PK_FEAS_REVIEW_STAT Bound Attachments |
| Name | Current Value |
| Feedback.PK_FEEDBACK |
| Entity Name | Feedback |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Feedback.PK_FEEDBACK Index Columns |
| ColumnName | Sort Order |
| Person Identifier | |
| Current Date |
| Feedback.PK_FEEDBACK Bound Attachments |
| Name | Current Value |
| Frequently Asked Question.PK794 |
| Entity Name | Frequently Asked Question |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Frequently Asked Question.PK794 Index Columns |
| ColumnName | Sort Order |
| Question | |
| Visible Code |
| Frequently Asked Question.PK794 Bound Attachments |
| Name | Current Value |
| Historical Proposal Type Map.PK_HIST_PRPSL_TYPE_MAP |
| Entity Name | Historical Proposal Type Map |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Historical Proposal Type Map.PK_HIST_PRPSL_TYPE_MAP Index Columns |
| ColumnName | Sort Order |
| Proposal Type Identifer | |
| Previous Proposal Type Identifier | |
| IPTS Version |
| Historical Proposal Type Map.PK_HIST_PRPSL_TYPE_MAP Bound Attachments |
| Name | Current Value |
| Industry Contact.PK_INDUS_CONT |
| Entity Name | Industry Contact |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Industry Contact.PK_INDUS_CONT Index Columns |
| ColumnName | Sort Order |
| Identifier |
| Industry Contact.PK_INDUS_CONT Bound Attachments |
| Name | Current Value |
| Industry Contact Instrument.PK_INDUS_CONT_INSTR |
| Entity Name | Industry Contact Instrument |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Industry Contact Instrument.PK_INDUS_CONT_INSTR Index Columns |
| ColumnName | Sort Order |
| Identifier | |
| Instrument Identifier |
| Industry Contact Instrument.PK_INDUS_CONT_INSTR Bound Attachments |
| Name | Current Value |
| Industry Contact Method.PK_INDUS_CONT_METH |
| Entity Name | Industry Contact Method |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Industry Contact Method.PK_INDUS_CONT_METH Index Columns |
| ColumnName | Sort Order |
| Preferred Contact Method Identifier |
| Industry Contact Method.PK_INDUS_CONT_METH Bound Attachments |
| Name | Current Value |
| Instrument.PK_INSTR |
| Entity Name | Instrument |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Instrument.PK_INSTR Index Columns |
| ColumnName | Sort Order |
| Instrument Identifier |
| Instrument.PK_INSTR Bound Attachments |
| Name | Current Value |
| Instrument Development Team Review.PK_IDT_REV |
| Entity Name | Instrument Development Team Review |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Instrument Development Team Review.PK_IDT_REV Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier | |
| Submission Number | |
| Instrument Identifier | |
| Person Identifier |
| Instrument Development Team Review.PK_IDT_REV Bound Attachments |
| Name | Current Value |
| Instrument Development Team Review Committee.PK_IDT_REV_COMM |
| Entity Name | Instrument Development Team Review Committee |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Instrument Development Team Review Committee.PK_IDT_REV_COMM Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier | |
| Submission Number | |
| Instrument Identifier |
| Instrument Development Team Review Committee.PK_IDT_REV_COMM Bound Attachments |
| Name | Current Value |
| Instrument Instrument Proposal Question Association.PK_INSTR_INSTR_PRPSL_ASSC |
| Entity Name | Instrument Instrument Proposal Question Association |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Instrument Instrument Proposal Question Association.PK_INSTR_INSTR_PRPSL_ASSC Index Columns |
| ColumnName | Sort Order |
| Question Identifier | |
| Instrument Identifier |
| Instrument Instrument Proposal Question Association.PK_INSTR_INSTR_PRPSL_ASSC Bound Attachments |
| Name | Current Value |
| Instrument Program Development Review Association.PK_INSTR_PDRC_ASSC |
| Entity Name | Instrument Program Development Review Association |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Instrument Program Development Review Association.PK_INSTR_PDRC_ASSC Index Columns |
| ColumnName | Sort Order |
| INSTR_ID | |
| Role Identifer | |
| Person Identifier |
| Instrument Program Development Review Association.PK_INSTR_PDRC_ASSC Bound Attachments |
| Name | Current Value |
| Instrument Proposal Question.PK_INSTR_PRPSL_QUES |
| Entity Name | Instrument Proposal Question |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Instrument Proposal Question.PK_INSTR_PRPSL_QUES Index Columns |
| ColumnName | Sort Order |
| Question Identifier |
| Instrument Proposal Question.PK_INSTR_PRPSL_QUES Bound Attachments |
| Name | Current Value |
| Instrument Proposal Type SoR Association.PK_INSTR_PRPSL_TYPE_SOR_ASSC |
| Entity Name | Instrument Proposal Type SoR Association |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Instrument Proposal Type SoR Association.PK_INSTR_PRPSL_TYPE_SOR_ASSC Index Columns |
| ColumnName | Sort Order |
| Instrument Identifier | |
| Proposal Type Identifer |
| Instrument Proposal Type SoR Association.PK_INSTR_PRPSL_TYPE_SOR_ASSC Bound Attachments |
| Name | Current Value |
| Integrated Proposal System Activity.PK_IPTS_ACT |
| Entity Name | Integrated Proposal System Activity |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Integrated Proposal System Activity.PK_IPTS_ACT Index Columns |
| ColumnName | Sort Order |
| Activity Identifier |
| Integrated Proposal System Activity.PK_IPTS_ACT Bound Attachments |
| Name | Current Value |
| Integrated Proposal System Log.PK_IPTS_LOG |
| Entity Name | Integrated Proposal System Log |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Integrated Proposal System Log.PK_IPTS_LOG Index Columns |
| ColumnName | Sort Order |
| Activity Identifier | |
| Modify Date |
| Integrated Proposal System Log.PK_IPTS_LOG Bound Attachments |
| Name | Current Value |
| IPTS Project Tracking.PK_IPTS_PROJ_TRACK |
| Entity Name | IPTS Project Tracking |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| IPTS Project Tracking.PK_IPTS_PROJ_TRACK Index Columns |
| ColumnName | Sort Order |
| Tracking Identifier |
| IPTS Project Tracking.PK_IPTS_PROJ_TRACK Bound Attachments |
| Name | Current Value |
| IPTS Release Number.PK_IPTS_REL_NBR |
| Entity Name | IPTS Release Number |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| IPTS Release Number.PK_IPTS_REL_NBR Index Columns |
| ColumnName | Sort Order |
| Release Identifier |
| IPTS Release Number.PK_IPTS_REL_NBR Bound Attachments |
| Name | Current Value |
| Laboratory Hazard Analysis.PK_LAB_HAZ_ANAL |
| Entity Name | Laboratory Hazard Analysis |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Laboratory Hazard Analysis.PK_LAB_HAZ_ANAL Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier | |
| Submission Number | |
| Instrument Identifier | |
| Run Number |
| Laboratory Hazard Analysis.PK_LAB_HAZ_ANAL Bound Attachments |
| Name | Current Value |
| Laboratory Hazard Analysis Control Association.PK_LAB_HAZ_ANAL_CTRL_ASSC |
| Entity Name | Laboratory Hazard Analysis Control Association |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Laboratory Hazard Analysis Control Association.PK_LAB_HAZ_ANAL_CTRL_ASSC Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier | |
| Submission Number | |
| Run Number | |
| Laboratory PPE Identifier | |
| Instrument Identifier |
| Laboratory Hazard Analysis Control Association.PK_LAB_HAZ_ANAL_CTRL_ASSC Bound Attachments |
| Name | Current Value |
| Laboratory Personal Protection Equipment.PK_LAB_PPE |
| Entity Name | Laboratory Personal Protection Equipment |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Laboratory Personal Protection Equipment.PK_LAB_PPE Index Columns |
| ColumnName | Sort Order |
| Laboratory PPE Identifier |
| Laboratory Personal Protection Equipment.PK_LAB_PPE Bound Attachments |
| Name | Current Value |
| Laboratory Training.PK_LAB_TRAIN |
| Entity Name | Laboratory Training |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Laboratory Training.PK_LAB_TRAIN Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier | |
| Submission Number | |
| Run Number | |
| Person Identifier | |
| Instrument Identifier |
| Laboratory Training.PK_LAB_TRAIN Bound Attachments |
| Name | Current Value |
| Member Role.PK_MBR_ROLE |
| Entity Name | Member Role |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Member Role.PK_MBR_ROLE Index Columns |
| ColumnName | Sort Order |
| Member Role Identifier |
| Member Role.PK_MBR_ROLE Bound Attachments |
| Name | Current Value |
| Nonvalidated Experiment Team Member.PK_NONVAL_EXPT_TEAM_MBR |
| Entity Name | Nonvalidated Experiment Team Member |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Nonvalidated Experiment Team Member.PK_NONVAL_EXPT_TEAM_MBR Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier | |
| Submission Number | |
| Email Address |
| Nonvalidated Experiment Team Member.PK_NONVAL_EXPT_TEAM_MBR Bound Attachments |
| Name | Current Value |
| Nonvalidated Experiment Team Member.FK_NONVAL_EXPT_TM_INST |
| Entity Name | Nonvalidated Experiment Team Member |
| Logical Only | NO |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| Key Type | Inversion Entry |
| Nonvalidated Experiment Team Member.FK_NONVAL_EXPT_TM_INST Index Columns |
| ColumnName | Sort Order |
| INST_ID |
| Nonvalidated Experiment Team Member.FK_NONVAL_EXPT_TM_INST Bound Attachments |
| Name | Current Value |
| NonValidated Person.PK_NONVAL_PERSON |
| Entity Name | NonValidated Person |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| NonValidated Person.PK_NONVAL_PERSON Index Columns |
| ColumnName | Sort Order |
| Email Address |
| NonValidated Person.PK_NONVAL_PERSON Bound Attachments |
| Name | Current Value |
| Nonvalidated Proposal Team Member Onsite Access.PK_NONVAL_PRPSL_TM_ONSITE_ACC |
| Entity Name | Nonvalidated Proposal Team Member Onsite Access |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Nonvalidated Proposal Team Member Onsite Access.PK_NONVAL_PRPSL_TM_ONSITE_ACC Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier | |
| Submission Number | |
| Email Address |
| Nonvalidated Proposal Team Member Onsite Access.PK_NONVAL_PRPSL_TM_ONSITE_ACC Bound Attachments |
| Name | Current Value |
| Nonvalidated Team Mbr Onsite Experiment Sched Association.PK_NONVAL_TM_ONSITE_EXPT_SCH_ASSC |
| Entity Name | Nonvalidated Team Mbr Onsite Experiment Sched Association |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Nonvalidated Team Mbr Onsite Experiment Sched Association.PK_NONVAL_TM_ONSITE_EXPT_SCH_ASSC Index Columns |
| ColumnName | Sort Order |
| Experiment Start Date | |
| Proposal Identifier | |
| Submission Number | |
| Email Address |
| Nonvalidated Team Mbr Onsite Experiment Sched Association.PK_NONVAL_TM_ONSITE_EXPT_SCH_ASSC Bound Attachments |
| Name | Current Value |
| Operational Feasibility Review Category.PK_OPER_FEAS_REV_CAT |
| Entity Name | Operational Feasibility Review Category |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Operational Feasibility Review Category.PK_OPER_FEAS_REV_CAT Index Columns |
| ColumnName | Sort Order |
| Category Identifier |
| Operational Feasibility Review Category.PK_OPER_FEAS_REV_CAT Bound Attachments |
| Name | Current Value |
| Operational Feasibility Review Status.PK_OPER_FEAS_REV_STAT |
| Entity Name | Operational Feasibility Review Status |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Operational Feasibility Review Status.PK_OPER_FEAS_REV_STAT Index Columns |
| ColumnName | Sort Order |
| Operational Feasibility Review Status Identifier |
| Operational Feasibility Review Status.PK_OPER_FEAS_REV_STAT Bound Attachments |
| Name | Current Value |
| Page Help.PK_PAGE_HELP |
| Entity Name | Page Help |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Page Help.PK_PAGE_HELP Index Columns |
| ColumnName | Sort Order |
| Page Id |
| Page Help.PK_PAGE_HELP Bound Attachments |
| Name | Current Value |
| Person.PK_PERSON |
| Entity Name | Person |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Person.PK_PERSON Index Columns |
| ColumnName | Sort Order |
| Person Identifier |
| Person.PK_PERSON Bound Attachments |
| Name | Current Value |
| Person.idx_username |
| Entity Name | Person |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | Alternate Key |
| Person.idx_username Index Columns |
| ColumnName | Sort Order |
| Username |
| Person.idx_username Bound Attachments |
| Name | Current Value |
| Person PDF.PK_PERSON_PDF |
| Entity Name | Person PDF |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Person PDF.PK_PERSON_PDF Index Columns |
| ColumnName | Sort Order |
| Person Identifier |
| Person PDF.PK_PERSON_PDF Bound Attachments |
| Name | Current Value |
| Person Research Area Association.PK_PERS_RSCH_AREA_ASSC |
| Entity Name | Person Research Area Association |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Person Research Area Association.PK_PERS_RSCH_AREA_ASSC Index Columns |
| ColumnName | Sort Order |
| Research Area Identifier | |
| Person Identifier |
| Person Research Area Association.PK_PERS_RSCH_AREA_ASSC Bound Attachments |
| Name | Current Value |
| Program Development Proposal Review.PK_PROG_DEV_PRPSL_REV |
| Entity Name | Program Development Proposal Review |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Program Development Proposal Review.PK_PROG_DEV_PRPSL_REV Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier | |
| PERSON_ID |
| Program Development Proposal Review.PK_PROG_DEV_PRPSL_REV Bound Attachments |
| Name | Current Value |
| Program Development Review Committee.PK_PROG_DEV_REV_COMM |
| Entity Name | Program Development Review Committee |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Program Development Review Committee.PK_PROG_DEV_REV_COMM Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier |
| Program Development Review Committee.PK_PROG_DEV_REV_COMM Bound Attachments |
| Name | Current Value |
| Project Task.PK_TASK_ID |
| Entity Name | Project Task |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Project Task.PK_TASK_ID Index Columns |
| ColumnName | Sort Order |
| Task Identifier |
| Project Task.PK_TASK_ID Bound Attachments |
| Name | Current Value |
| Proposal.PK_PROPOSAL |
| Entity Name | Proposal |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal.PK_PROPOSAL Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier |
| Proposal.PK_PROPOSAL Bound Attachments |
| Name | Current Value |
| Proposal.PROPOSAL_SOR_INDEX |
| Entity Name | Proposal |
| Logical Only | NO |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| Key Type | Inversion Entry |
| Proposal.PROPOSAL_SOR_INDEX Index Columns |
| ColumnName | Sort Order |
| Statement of Research |
| Proposal.PROPOSAL_SOR_INDEX Bound Attachments |
| Name | Current Value |
| Proposal.IDX_PRPSL_STAT_IND |
| Entity Name | Proposal |
| Logical Only | NO |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| Key Type | Inversion Entry |
| Proposal.IDX_PRPSL_STAT_IND Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier | |
| Status Identifier |
| Proposal.IDX_PRPSL_STAT_IND Bound Attachments |
| Name | Current Value |
| Proposal.FK_PRPSL_PRPSL_STAT |
| Entity Name | Proposal |
| Logical Only | NO |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| Key Type | Inversion Entry |
| Proposal.FK_PRPSL_PRPSL_STAT Index Columns |
| ColumnName | Sort Order |
| Status Identifier |
| Proposal.FK_PRPSL_PRPSL_STAT Bound Attachments |
| Name | Current Value |
| Proposal.FK_PRPSL_USR_CAT |
| Entity Name | Proposal |
| Logical Only | NO |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| Key Type | Inversion Entry |
| Proposal.FK_PRPSL_USR_CAT Index Columns |
| ColumnName | Sort Order |
| Proposal Type Identifer |
| Proposal.FK_PRPSL_USR_CAT Bound Attachments |
| Name | Current Value |
| Proposal Activity.PK_PRPSL_ACT |
| Entity Name | Proposal Activity |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal Activity.PK_PRPSL_ACT Index Columns |
| ColumnName | Sort Order |
| Activity Identifier |
| Proposal Activity.PK_PRPSL_ACT Bound Attachments |
| Name | Current Value |
| Proposal Attachment.PK_PRPSL_ATTACH |
| Entity Name | Proposal Attachment |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal Attachment.PK_PRPSL_ATTACH Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier | |
| Submission Number | |
| Activity Identifier | |
| Attachment Sequence |
| Proposal Attachment.PK_PRPSL_ATTACH Bound Attachments |
| Name | Current Value |
| Proposal BES Research Area.PK_PRPSL_RSCH_AREA |
| Entity Name | Proposal BES Research Area |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal BES Research Area.PK_PRPSL_RSCH_AREA Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier | |
| Research Area Identifier |
| Proposal BES Research Area.PK_PRPSL_RSCH_AREA Bound Attachments |
| Name | Current Value |
| Proposal BES Research Area.FK_PRPSL_PRPSL_RSCH_AREA |
| Entity Name | Proposal BES Research Area |
| Logical Only | NO |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| Key Type | Inversion Entry |
| Proposal BES Research Area.FK_PRPSL_PRPSL_RSCH_AREA Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier |
| Proposal BES Research Area.FK_PRPSL_PRPSL_RSCH_AREA Bound Attachments |
| Name | Current Value |
| Proposal BES Research Area.FK_RSCH_AREA_PRPSL_RA |
| Entity Name | Proposal BES Research Area |
| Logical Only | NO |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| Key Type | Inversion Entry |
| Proposal BES Research Area.FK_RSCH_AREA_PRPSL_RA Index Columns |
| ColumnName | Sort Order |
| Research Area Identifier |
| Proposal BES Research Area.FK_RSCH_AREA_PRPSL_RA Bound Attachments |
| Name | Current Value |
| Proposal Clarification.PK_PRPSL_CLAR |
| Entity Name | Proposal Clarification |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal Clarification.PK_PRPSL_CLAR Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier | |
| Submission Number | |
| Instrument Identifier | |
| Person Identifier | |
| Current Date |
| Proposal Clarification.PK_PRPSL_CLAR Bound Attachments |
| Name | Current Value |
| Proposal Clarification.FK_PRPSL_CLAR_COL_CLAR |
| Entity Name | Proposal Clarification |
| Logical Only | NO |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| Key Type | Inversion Entry |
| Proposal Clarification.FK_PRPSL_CLAR_COL_CLAR Index Columns |
| ColumnName | Sort Order |
| Current Date |
| Proposal Clarification.FK_PRPSL_CLAR_COL_CLAR Bound Attachments |
| Name | Current Value |
| Proposal Clarification.FK_PER_PRPSL_CLAR |
| Entity Name | Proposal Clarification |
| Logical Only | NO |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| Key Type | Inversion Entry |
| Proposal Clarification.FK_PER_PRPSL_CLAR Index Columns |
| ColumnName | Sort Order |
| Person Identifier |
| Proposal Clarification.FK_PER_PRPSL_CLAR Bound Attachments |
| Name | Current Value |
| Proposal Continuation Justification.PK_PRPSL_CONT_JUST |
| Entity Name | Proposal Continuation Justification |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal Continuation Justification.PK_PRPSL_CONT_JUST Index Columns |
| ColumnName | Sort Order |
| Continuation Justification Identifier |
| Proposal Continuation Justification.PK_PRPSL_CONT_JUST Bound Attachments |
| Name | Current Value |
| Proposal ESH Clarification.PK_PRPSL_ESH_CLAR |
| Entity Name | Proposal ESH Clarification |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal ESH Clarification.PK_PRPSL_ESH_CLAR Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier | |
| Submission Number | |
| Person Identifier | |
| Sequence Identifer |
| Proposal ESH Clarification.PK_PRPSL_ESH_CLAR Bound Attachments |
| Name | Current Value |
| Proposal ESS Approval.PK_PRPSL_ESS_APPR |
| Entity Name | Proposal ESS Approval |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal ESS Approval.PK_PRPSL_ESS_APPR Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier | |
| Submission Number | |
| Instrument Identifier | |
| Run Number | |
| Person Identifier | |
| Role Identifier |
| Proposal ESS Approval.PK_PRPSL_ESS_APPR Bound Attachments |
| Name | Current Value |
| Proposal Facility.PK_PRPSL_FACIL |
| Entity Name | Proposal Facility |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal Facility.PK_PRPSL_FACIL Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier | |
| Submission Number | |
| Facility Identifier |
| Proposal Facility.PK_PRPSL_FACIL Bound Attachments |
| Name | Current Value |
| Proposal Facility.PRPSL_FACIL_IND1 |
| Entity Name | Proposal Facility |
| Logical Only | NO |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| Key Type | Inversion Entry |
| Proposal Facility.PRPSL_FACIL_IND1 Index Columns |
| ColumnName | Sort Order |
| Run Cycle Identifier |
| Proposal Facility.PRPSL_FACIL_IND1 Bound Attachments |
| Name | Current Value |
| Proposal Facility.REF5181074 |
| Entity Name | Proposal Facility |
| Logical Only | NO |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| Key Type | Inversion Entry |
| Proposal Facility.REF5181074 Index Columns |
| ColumnName | Sort Order |
| Facility Identifier |
| Proposal Facility.REF5181074 Bound Attachments |
| Name | Current Value |
| Proposal Feasibility Review.PK_PRPSL_FEAS_REV |
| Entity Name | Proposal Feasibility Review |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal Feasibility Review.PK_PRPSL_FEAS_REV Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier | |
| Submission Number | |
| Instrument Identifier | |
| Feasibility Review Category Identifier | |
| Feasibility Review Status Identifier |
| Proposal Feasibility Review.PK_PRPSL_FEAS_REV Bound Attachments |
| Name | Current Value |
| Proposal Feasibility Review History.PK_PRPSL_FEAS_REV_HIST |
| Entity Name | Proposal Feasibility Review History |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal Feasibility Review History.PK_PRPSL_FEAS_REV_HIST Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier | |
| Submission Number | |
| Instrument Identifier | |
| Feasibility Review Category Identifier | |
| Feasibility Review Status Identifier | |
| Current Date |
| Proposal Feasibility Review History.PK_PRPSL_FEAS_REV_HIST Bound Attachments |
| Name | Current Value |
| Proposal Funding.PK_PRPSL_FUND |
| Entity Name | Proposal Funding |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal Funding.PK_PRPSL_FUND Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier | |
| FUND_ID |
| Proposal Funding.PK_PRPSL_FUND Bound Attachments |
| Name | Current Value |
| Proposal Funding.FK_PRPSL_FUND_PRPSL |
| Entity Name | Proposal Funding |
| Logical Only | NO |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| Key Type | Inversion Entry |
| Proposal Funding.FK_PRPSL_FUND_PRPSL Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier |
| Proposal Funding.FK_PRPSL_FUND_PRPSL Bound Attachments |
| Name | Current Value |
| Proposal Funding.FK_PRPSL_FUND_FUND_SRC |
| Entity Name | Proposal Funding |
| Logical Only | NO |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| Key Type | Inversion Entry |
| Proposal Funding.FK_PRPSL_FUND_FUND_SRC Index Columns |
| ColumnName | Sort Order |
| FUND_ID |
| Proposal Funding.FK_PRPSL_FUND_FUND_SRC Bound Attachments |
| Name | Current Value |
| Proposal Instrument.PK_PRPSL_INSTR |
| Entity Name | Proposal Instrument |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal Instrument.PK_PRPSL_INSTR Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier | |
| Submission Number | |
| Instrument Identifier |
| Proposal Instrument.PK_PRPSL_INSTR Bound Attachments |
| Name | Current Value |
| Proposal Instrument.PRPSL_INSTR_IND1 |
| Entity Name | Proposal Instrument |
| Logical Only | NO |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| Key Type | Inversion Entry |
| Proposal Instrument.PRPSL_INSTR_IND1 Index Columns |
| ColumnName | Sort Order |
| Instrument Identifier | |
| Instrument Preference |
| Proposal Instrument.PRPSL_INSTR_IND1 Bound Attachments |
| Name | Current Value |
| Proposal Instrument.FK_INSTR_PRPSL_INSTR |
| Entity Name | Proposal Instrument |
| Logical Only | NO |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| Key Type | Inversion Entry |
| Proposal Instrument.FK_INSTR_PRPSL_INSTR Index Columns |
| ColumnName | Sort Order |
| Instrument Identifier |
| Proposal Instrument.FK_INSTR_PRPSL_INSTR Bound Attachments |
| Name | Current Value |
| Proposal Instrument Group Chair Review.PK_PRPSL_INSTR_GRP_CHAIR_REV |
| Entity Name | Proposal Instrument Group Chair Review |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal Instrument Group Chair Review.PK_PRPSL_INSTR_GRP_CHAIR_REV Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier | |
| Submission Number | |
| FACIL_ID | |
| GRP_ID | |
| PERSON_ID |
| Proposal Instrument Group Chair Review.PK_PRPSL_INSTR_GRP_CHAIR_REV Bound Attachments |
| Name | Current Value |
| Proposal Instrument Operational Review Category Association.PK_PI_OPER_REV_CAT_ASSC |
| Entity Name | Proposal Instrument Operational Review Category Association |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal Instrument Operational Review Category Association.PK_PI_OPER_REV_CAT_ASSC Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier | |
| Submission Number | |
| Instrument Identifier | |
| Category Identifier |
| Proposal Instrument Operational Review Category Association.PK_PI_OPER_REV_CAT_ASSC Bound Attachments |
| Name | Current Value |
| Proposal Instrument Question.PK_PRPSL_INSTR_QUES |
| Entity Name | Proposal Instrument Question |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal Instrument Question.PK_PRPSL_INSTR_QUES Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier | |
| Submission Number | |
| Instrument Identifier | |
| Question Identifier |
| Proposal Instrument Question.PK_PRPSL_INSTR_QUES Bound Attachments |
| Name | Current Value |
| Proposal Instrument Sample Environment Association.PK_PRPSL_INSTR_SMPL_ENV_ASSC |
| Entity Name | Proposal Instrument Sample Environment Association |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal Instrument Sample Environment Association.PK_PRPSL_INSTR_SMPL_ENV_ASSC Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier | |
| Submission Number | |
| Sample Environment Identifier | |
| Instrument Identifier |
| Proposal Instrument Sample Environment Association.PK_PRPSL_INSTR_SMPL_ENV_ASSC Bound Attachments |
| Name | Current Value |
| Proposal Instrument Status.PK_PRPSL_INSTR_STAT |
| Entity Name | Proposal Instrument Status |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal Instrument Status.PK_PRPSL_INSTR_STAT Index Columns |
| ColumnName | Sort Order |
| Status Identifier |
| Proposal Instrument Status.PK_PRPSL_INSTR_STAT Bound Attachments |
| Name | Current Value |
| Proposal Laboratory Request.PK_PRPSL_LAB_REQ |
| Entity Name | Proposal Laboratory Request |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal Laboratory Request.PK_PRPSL_LAB_REQ Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier | |
| Submission Number |
| Proposal Laboratory Request.PK_PRPSL_LAB_REQ Bound Attachments |
| Name | Current Value |
| Proposal Laboratory Request Chemical Association.PK_PRPSL_LAB_REQ_CHEM_ASSC |
| Entity Name | Proposal Laboratory Request Chemical Association |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal Laboratory Request Chemical Association.PK_PRPSL_LAB_REQ_CHEM_ASSC Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier | |
| Submission Number | |
| Chemical Name |
| Proposal Laboratory Request Chemical Association.PK_PRPSL_LAB_REQ_CHEM_ASSC Bound Attachments |
| Name | Current Value |
| Proposal Laboratory Request Chemical PPE Association.PK_LAB_REQ_CHEM_PPE_ASSC |
| Entity Name | Proposal Laboratory Request Chemical PPE Association |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal Laboratory Request Chemical PPE Association.PK_LAB_REQ_CHEM_PPE_ASSC Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier | |
| Submission Number | |
| Chemical Name | |
| LAB_PPE_ID |
| Proposal Laboratory Request Chemical PPE Association.PK_LAB_REQ_CHEM_PPE_ASSC Bound Attachments |
| Name | Current Value |
| Proposal Laboratory Request Facility Assignment.PK_PRPSL_LAB_REQ_FACIL_ASGN |
| Entity Name | Proposal Laboratory Request Facility Assignment |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal Laboratory Request Facility Assignment.PK_PRPSL_LAB_REQ_FACIL_ASGN Index Columns |
| ColumnName | Sort Order |
| Facility Identifier | |
| Proposal Identifier | |
| Submission Number |
| Proposal Laboratory Request Facility Assignment.PK_PRPSL_LAB_REQ_FACIL_ASGN Bound Attachments |
| Name | Current Value |
| Proposal Laboratory Request Hazard Analysis.PK_PRPSL_LAB_REQ_HAZ_ANAL |
| Entity Name | Proposal Laboratory Request Hazard Analysis |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal Laboratory Request Hazard Analysis.PK_PRPSL_LAB_REQ_HAZ_ANAL Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier | |
| Submission Number |
| Proposal Laboratory Request Hazard Analysis.PK_PRPSL_LAB_REQ_HAZ_ANAL Bound Attachments |
| Name | Current Value |
| Proposal Laboratory Request Hazard Analysis Control Association.PK_PRPSL_LAB_REQ_HAZ_ANL_CTL_ASSC |
| Entity Name | Proposal Laboratory Request Hazard Analysis Control Association |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal Laboratory Request Hazard Analysis Control Association.PK_PRPSL_LAB_REQ_HAZ_ANL_CTL_ASSC Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier | |
| Submission Number | |
| Laboratory PPE Identifier |
| Proposal Laboratory Request Hazard Analysis Control Association.PK_PRPSL_LAB_REQ_HAZ_ANL_CTL_ASSC Bound Attachments |
| Name | Current Value |
| Proposal Laboratory Request Hazard Association.PK_PRPSL_LAB_REQ_HAZ_ASSC |
| Entity Name | Proposal Laboratory Request Hazard Association |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal Laboratory Request Hazard Association.PK_PRPSL_LAB_REQ_HAZ_ASSC Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier | |
| Submission Number | |
| Chemical Name | |
| SMPL_HAZ_ID |
| Proposal Laboratory Request Hazard Association.PK_PRPSL_LAB_REQ_HAZ_ASSC Bound Attachments |
| Name | Current Value |
| Proposal Laboratory Request Team Member Association.PK_PRPSL_LAB_REQ_TM_ASSC |
| Entity Name | Proposal Laboratory Request Team Member Association |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal Laboratory Request Team Member Association.PK_PRPSL_LAB_REQ_TM_ASSC Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier | |
| Submission Number | |
| Sequence Identifier |
| Proposal Laboratory Request Team Member Association.PK_PRPSL_LAB_REQ_TM_ASSC Bound Attachments |
| Name | Current Value |
| Proposal Laboratory Request Usage Association.PK_LAB_REQ_USAGE_ASSC |
| Entity Name | Proposal Laboratory Request Usage Association |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal Laboratory Request Usage Association.PK_LAB_REQ_USAGE_ASSC Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier | |
| Submission Number | |
| Usage Type Identifier |
| Proposal Laboratory Request Usage Association.PK_LAB_REQ_USAGE_ASSC Bound Attachments |
| Name | Current Value |
| Proposal Laboratory Special Request Association.PK_PRPSL_LAB_SPEC_ASSC |
| Entity Name | Proposal Laboratory Special Request Association |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal Laboratory Special Request Association.PK_PRPSL_LAB_SPEC_ASSC Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier | |
| Submission Number | |
| Special Request Identifier |
| Proposal Laboratory Special Request Association.PK_PRPSL_LAB_SPEC_ASSC Bound Attachments |
| Name | Current Value |
| Proposal Laboratory Special Request Type.PK_PRPSL_LAB_SPEC_REQ_TYPE |
| Entity Name | Proposal Laboratory Special Request Type |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal Laboratory Special Request Type.PK_PRPSL_LAB_SPEC_REQ_TYPE Index Columns |
| ColumnName | Sort Order |
| Special Request Identifier |
| Proposal Laboratory Special Request Type.PK_PRPSL_LAB_SPEC_REQ_TYPE Bound Attachments |
| Name | Current Value |
| Proposal Laboratory Usage Level.PK_PRPSL_LAB_USAGE_LVL |
| Entity Name | Proposal Laboratory Usage Level |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal Laboratory Usage Level.PK_PRPSL_LAB_USAGE_LVL Index Columns |
| ColumnName | Sort Order |
| Work Level Identifier |
| Proposal Laboratory Usage Level.PK_PRPSL_LAB_USAGE_LVL Bound Attachments |
| Name | Current Value |
| Proposal Laboratory Usage Type.PK_PRPSL_LAB_USAGE_TYPE |
| Entity Name | Proposal Laboratory Usage Type |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal Laboratory Usage Type.PK_PRPSL_LAB_USAGE_TYPE Index Columns |
| ColumnName | Sort Order |
| Usage Type Identifier |
| Proposal Laboratory Usage Type.PK_PRPSL_LAB_USAGE_TYPE Bound Attachments |
| Name | Current Value |
| Proposal Log.PK_PRPSL_LOG |
| Entity Name | Proposal Log |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal Log.PK_PRPSL_LOG Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier | |
| Submission Number | |
| Modify Date | |
| Activity Identifier |
| Proposal Log.PK_PRPSL_LOG Bound Attachments |
| Name | Current Value |
| Proposal Log.FK_PRPSL_LOG_PRPSL_ACT |
| Entity Name | Proposal Log |
| Logical Only | NO |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| Key Type | Inversion Entry |
| Proposal Log.FK_PRPSL_LOG_PRPSL_ACT Index Columns |
| ColumnName | Sort Order |
| Activity Identifier |
| Proposal Log.FK_PRPSL_LOG_PRPSL_ACT Bound Attachments |
| Name | Current Value |
| Proposal Operation Review Clarification.PK_PRPSL_OPN_REV_CLAR |
| Entity Name | Proposal Operation Review Clarification |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal Operation Review Clarification.PK_PRPSL_OPN_REV_CLAR Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier | |
| Submission Number | |
| Person Identifier | |
| Sequence Identifer |
| Proposal Operation Review Clarification.PK_PRPSL_OPN_REV_CLAR Bound Attachments |
| Name | Current Value |
| Proposal PDF.PK_PRPSL_PDF |
| Entity Name | Proposal PDF |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal PDF.PK_PRPSL_PDF Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier | |
| Submission Number |
| Proposal PDF.PK_PRPSL_PDF Bound Attachments |
| Name | Current Value |
| Proposal Publication Association.PK_RECENT_PUB |
| Entity Name | Proposal Publication Association |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal Publication Association.PK_RECENT_PUB Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier | |
| Publication Identifer |
| Proposal Publication Association.PK_RECENT_PUB Bound Attachments |
| Name | Current Value |
| Proposal Research Area.PK_PRPSL_RSCH_AREA |
| Entity Name | Proposal Research Area |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal Research Area.PK_PRPSL_RSCH_AREA Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier | |
| Research Area Identifier |
| Proposal Research Area.PK_PRPSL_RSCH_AREA Bound Attachments |
| Name | Current Value |
| Proposal Review.PK_PRPSL_REVIEW |
| Entity Name | Proposal Review |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal Review.PK_PRPSL_REVIEW Index Columns |
| ColumnName | Sort Order |
| Review Identifier |
| Proposal Review.PK_PRPSL_REVIEW Bound Attachments |
| Name | Current Value |
| Proposal Review Status.PK_PRPSL_REVIEW_STAT |
| Entity Name | Proposal Review Status |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal Review Status.PK_PRPSL_REVIEW_STAT Index Columns |
| ColumnName | Sort Order |
| Review Status Identifier |
| Proposal Review Status.PK_PRPSL_REVIEW_STAT Bound Attachments |
| Name | Current Value |
| Proposal Review Workflow.PK_PRPSL_WRKFLW |
| Entity Name | Proposal Review Workflow |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal Review Workflow.PK_PRPSL_WRKFLW Index Columns |
| ColumnName | Sort Order |
| Proposal Type Identifer | |
| WorkFlow Identifier | |
| Order Number |
| Proposal Review Workflow.PK_PRPSL_WRKFLW Bound Attachments |
| Name | Current Value |
| Proposal Role.PK_PRPSL_ROLE |
| Entity Name | Proposal Role |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal Role.PK_PRPSL_ROLE Index Columns |
| ColumnName | Sort Order |
| Role Identifer |
| Proposal Role.PK_PRPSL_ROLE Bound Attachments |
| Name | Current Value |
| Proposal Role Person Association.PK_PRPSL_ROLE_PERS_ASSC |
| Entity Name | Proposal Role Person Association |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal Role Person Association.PK_PRPSL_ROLE_PERS_ASSC Index Columns |
| ColumnName | Sort Order |
| Role Identifer | |
| Person Identifier |
| Proposal Role Person Association.PK_PRPSL_ROLE_PERS_ASSC Bound Attachments |
| Name | Current Value |
| Proposal Role Person Association.FK_PRPSL_ROLE_PRP_ASSC |
| Entity Name | Proposal Role Person Association |
| Logical Only | NO |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| Key Type | Inversion Entry |
| Proposal Role Person Association.FK_PRPSL_ROLE_PRP_ASSC Index Columns |
| ColumnName | Sort Order |
| Role Identifer |
| Proposal Role Person Association.FK_PRPSL_ROLE_PRP_ASSC Bound Attachments |
| Name | Current Value |
| Proposal Role Person Association.FK_PER_PRPSL_ROLE_ASSC |
| Entity Name | Proposal Role Person Association |
| Logical Only | NO |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| Key Type | Inversion Entry |
| Proposal Role Person Association.FK_PER_PRPSL_ROLE_ASSC Index Columns |
| ColumnName | Sort Order |
| Person Identifier |
| Proposal Role Person Association.FK_PER_PRPSL_ROLE_ASSC Bound Attachments |
| Name | Current Value |
| Proposal Science Review.PK_PRPSL_SCI_REVIEW |
| Entity Name | Proposal Science Review |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal Science Review.PK_PRPSL_SCI_REVIEW Index Columns |
| ColumnName | Sort Order |
| Person Identifier | |
| Proposal Identifier | |
| Submission Number | |
| Instrument Identifier |
| Proposal Science Review.PK_PRPSL_SCI_REVIEW Bound Attachments |
| Name | Current Value |
| Proposal Science Review.PRPSL_SCI_REV_PERS |
| Entity Name | Proposal Science Review |
| Logical Only | NO |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| Key Type | Inversion Entry |
| Proposal Science Review.PRPSL_SCI_REV_PERS Index Columns |
| ColumnName | Sort Order |
| Person Identifier | |
| Submitted Indicator |
| Proposal Science Review.PRPSL_SCI_REV_PERS Bound Attachments |
| Name | Current Value |
| Proposal Science Review.FK_PRPSL_SCI_RV_CRIT_TEAM_ABIL |
| Entity Name | Proposal Science Review |
| Logical Only | NO |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| Key Type | Inversion Entry |
| Proposal Science Review.FK_PRPSL_SCI_RV_CRIT_TEAM_ABIL Index Columns |
| ColumnName | Sort Order |
| Criteria Identifier |
| Proposal Science Review.FK_PRPSL_SCI_RV_CRIT_TEAM_ABIL Bound Attachments |
| Name | Current Value |
| Proposal Science Review.FK_PRPSL_SCI_RV_SCI_RV_MERIT |
| Entity Name | Proposal Science Review |
| Logical Only | NO |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| Key Type | Inversion Entry |
| Proposal Science Review.FK_PRPSL_SCI_RV_SCI_RV_MERIT Index Columns |
| ColumnName | Sort Order |
| Rating Identifier |
| Proposal Science Review.FK_PRPSL_SCI_RV_SCI_RV_MERIT Bound Attachments |
| Name | Current Value |
| Proposal Science Review Committee Review.PK_PRPSL_SRC_REV |
| Entity Name | Proposal Science Review Committee Review |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal Science Review Committee Review.PK_PRPSL_SRC_REV Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier | |
| Submission Number | |
| Instrument Identifier | |
| Person Identifier |
| Proposal Science Review Committee Review.PK_PRPSL_SRC_REV Bound Attachments |
| Name | Current Value |
| Proposal SRCM to PI Standard Comment.PK_PRPSL_SRCM_PI_STD_CMNT |
| Entity Name | Proposal SRCM to PI Standard Comment |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal SRCM to PI Standard Comment.PK_PRPSL_SRCM_PI_STD_CMNT Index Columns |
| ColumnName | Sort Order |
| Comment Identifier |
| Proposal SRCM to PI Standard Comment.PK_PRPSL_SRCM_PI_STD_CMNT Bound Attachments |
| Name | Current Value |
| Proposal Status.PK_PRPSL_STAT |
| Entity Name | Proposal Status |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal Status.PK_PRPSL_STAT Index Columns |
| ColumnName | Sort Order |
| Status Identifier |
| Proposal Status.PK_PRPSL_STAT Bound Attachments |
| Name | Current Value |
| Proposal Subject Area.PK_PRPSL_SUBJ_AREA |
| Entity Name | Proposal Subject Area |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal Subject Area.PK_PRPSL_SUBJ_AREA Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier | |
| Subject Area Identifier |
| Proposal Subject Area.PK_PRPSL_SUBJ_AREA Bound Attachments |
| Name | Current Value |
| Proposal Submission.PK_PRPSL_SUBMISS |
| Entity Name | Proposal Submission |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal Submission.PK_PRPSL_SUBMISS Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier | |
| Submission Number |
| Proposal Submission.PK_PRPSL_SUBMISS Bound Attachments |
| Name | Current Value |
| Proposal Submission Status.PK_PRPSL_SUBMIS_STAT |
| Entity Name | Proposal Submission Status |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal Submission Status.PK_PRPSL_SUBMIS_STAT Index Columns |
| ColumnName | Sort Order |
| Status Identifier |
| Proposal Submission Status.PK_PRPSL_SUBMIS_STAT Bound Attachments |
| Name | Current Value |
| Proposal Team Member Onsite Access.PK_PRPSL_TM_ONSITE_ACC |
| Entity Name | Proposal Team Member Onsite Access |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal Team Member Onsite Access.PK_PRPSL_TM_ONSITE_ACC Index Columns |
| ColumnName | Sort Order |
| Person Identifier |
| Proposal Team Member Onsite Access.PK_PRPSL_TM_ONSITE_ACC Bound Attachments |
| Name | Current Value |
| Proposal Team Member Onsite Experiment Schedule Association.PK_PRPSL_TM_ON_EXPT_SCH_ASSC |
| Entity Name | Proposal Team Member Onsite Experiment Schedule Association |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal Team Member Onsite Experiment Schedule Association.PK_PRPSL_TM_ON_EXPT_SCH_ASSC Index Columns |
| ColumnName | Sort Order |
| Person Identifier | |
| Start Date |
| Proposal Team Member Onsite Experiment Schedule Association.PK_PRPSL_TM_ON_EXPT_SCH_ASSC Bound Attachments |
| Name | Current Value |
| Proposal Type.PK_PRPSL_TYPE |
| Entity Name | Proposal Type |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal Type.PK_PRPSL_TYPE Index Columns |
| ColumnName | Sort Order |
| Proposal Type Identifer |
| Proposal Type.PK_PRPSL_TYPE Bound Attachments |
| Name | Current Value |
| Proposal Type Instrument Association.PK_PRPSL_TYPE_INSTR_ASSC |
| Entity Name | Proposal Type Instrument Association |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal Type Instrument Association.PK_PRPSL_TYPE_INSTR_ASSC Index Columns |
| ColumnName | Sort Order |
| Proposal Type Identifer | |
| Instrument Identifier |
| Proposal Type Instrument Association.PK_PRPSL_TYPE_INSTR_ASSC Bound Attachments |
| Name | Current Value |
| Proposal Type Proposal Review Association.PK_PRPSL_TYPE_PRPSL_REV_ASSC |
| Entity Name | Proposal Type Proposal Review Association |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Proposal Type Proposal Review Association.PK_PRPSL_TYPE_PRPSL_REV_ASSC Index Columns |
| ColumnName | Sort Order |
| Proposal Type Identifer | |
| Review Identifier |
| Proposal Type Proposal Review Association.PK_PRPSL_TYPE_PRPSL_REV_ASSC Bound Attachments |
| Name | Current Value |
| Publication.PK_PUBL |
| Entity Name | Publication |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Publication.PK_PUBL Index Columns |
| ColumnName | Sort Order |
| Publication Identifer |
| Publication.PK_PUBL Bound Attachments |
| Name | Current Value |
| Related Proposal.PK_REL_PRPSL |
| Entity Name | Related Proposal |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Related Proposal.PK_REL_PRPSL Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier | |
| Related Proposal Identifier |
| Related Proposal.PK_REL_PRPSL Bound Attachments |
| Name | Current Value |
| Research Area.PK_RSCH_AREA |
| Entity Name | Research Area |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Research Area.PK_RSCH_AREA Index Columns |
| ColumnName | Sort Order |
| Research Area Identifier |
| Research Area.PK_RSCH_AREA Bound Attachments |
| Name | Current Value |
| Research Area BES Research Area Association.PK_RSCH_AREA_BES_RSCH_AREA_ASSC |
| Entity Name | Research Area BES Research Area Association |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Research Area BES Research Area Association.PK_RSCH_AREA_BES_RSCH_AREA_ASSC Index Columns |
| ColumnName | Sort Order |
| Research Area Identifier | |
| BES Research Area Identifier |
| Research Area BES Research Area Association.PK_RSCH_AREA_BES_RSCH_AREA_ASSC Bound Attachments |
| Name | Current Value |
| Research Area Instrument Association.PK_RSCH_AREA_INSTR_ASSC |
| Entity Name | Research Area Instrument Association |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Research Area Instrument Association.PK_RSCH_AREA_INSTR_ASSC Index Columns |
| ColumnName | Sort Order |
| Research Area Identifier | |
| Instrument Identifier |
| Research Area Instrument Association.PK_RSCH_AREA_INSTR_ASSC Bound Attachments |
| Name | Current Value |
| Research Area Person Association.PK2852 |
| Entity Name | Research Area Person Association |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Research Area Person Association.PK2852 Index Columns |
| ColumnName | Sort Order |
| Person Identifier | |
| Research Area Identifier |
| Research Area Person Association.PK2852 Bound Attachments |
| Name | Current Value |
| Review Subcommittee.PK_REV_SUBCOMM |
| Entity Name | Review Subcommittee |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Review Subcommittee.PK_REV_SUBCOMM Index Columns |
| ColumnName | Sort Order |
| Subcommittee Identifier |
| Review Subcommittee.PK_REV_SUBCOMM Bound Attachments |
| Name | Current Value |
| Review Subcommittee Proposal Association.PK_REV_SUBCOMM_PRPSL_ASSC |
| Entity Name | Review Subcommittee Proposal Association |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Review Subcommittee Proposal Association.PK_REV_SUBCOMM_PRPSL_ASSC Index Columns |
| ColumnName | Sort Order |
| Subcommittee Identifier | |
| Proposal Identifier | |
| Submission Number | |
| Instrument Identifier |
| Review Subcommittee Proposal Association.PK_REV_SUBCOMM_PRPSL_ASSC Bound Attachments |
| Name | Current Value |
| Run Cycle.PK_RUN_CYCLE |
| Entity Name | Run Cycle |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Run Cycle.PK_RUN_CYCLE Index Columns |
| ColumnName | Sort Order |
| Facility Identifier | |
| Run Cycle Identifier |
| Run Cycle.PK_RUN_CYCLE Bound Attachments |
| Name | Current Value |
| Run Cycle Instrument Request.PK_RUN_CYCLE_INSTR_REQ |
| Entity Name | Run Cycle Instrument Request |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Run Cycle Instrument Request.PK_RUN_CYCLE_INSTR_REQ Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier | |
| Facility Identifier | |
| Run Cycle Identifier | |
| Instrument Identifier |
| Run Cycle Instrument Request.PK_RUN_CYCLE_INSTR_REQ Bound Attachments |
| Name | Current Value |
| Safety Review Status.PK_SFTY_REVIEW_STAT |
| Entity Name | Safety Review Status |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Safety Review Status.PK_SFTY_REVIEW_STAT Index Columns |
| ColumnName | Sort Order |
| Safety Review Status Identifier |
| Safety Review Status.PK_SFTY_REVIEW_STAT Bound Attachments |
| Name | Current Value |
| Science Review Committee Finding.PK_SRCM_FINDING |
| Entity Name | Science Review Committee Finding |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Science Review Committee Finding.PK_SRCM_FINDING Index Columns |
| ColumnName | Sort Order |
| Finding Identifier |
| Science Review Committee Finding.PK_SRCM_FINDING Bound Attachments |
| Name | Current Value |
| Science Review Merit.PK_SCI_REVIEW_MERIT |
| Entity Name | Science Review Merit |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Science Review Merit.PK_SCI_REVIEW_MERIT Index Columns |
| ColumnName | Sort Order |
| Rating Identifier |
| Science Review Merit.PK_SCI_REVIEW_MERIT Bound Attachments |
| Name | Current Value |
| Science Review Status.PK_SCI_REVIEW_STAT |
| Entity Name | Science Review Status |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Science Review Status.PK_SCI_REVIEW_STAT Index Columns |
| ColumnName | Sort Order |
| Science Review Status Identifier |
| Science Review Status.PK_SCI_REVIEW_STAT Bound Attachments |
| Name | Current Value |
| Subject Area.PK_SUBJ_AREA |
| Entity Name | Subject Area |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Subject Area.PK_SUBJ_AREA Index Columns |
| ColumnName | Sort Order |
| Subject Area Identifier |
| Subject Area.PK_SUBJ_AREA Bound Attachments |
| Name | Current Value |
| Unavailable Date.PK_UNAVAIL_DTE |
| Entity Name | Unavailable Date |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Unavailable Date.PK_UNAVAIL_DTE Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier | |
| Submission Number | |
| Begin Date |
| Unavailable Date.PK_UNAVAIL_DTE Bound Attachments |
| Name | Current Value |
| Unit of Length.PK_UNIT_LEN |
| Entity Name | Unit of Length |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Unit of Length.PK_UNIT_LEN Index Columns |
| ColumnName | Sort Order |
| Length Unit Identifier |
| Unit of Length.PK_UNIT_LEN Bound Attachments |
| Name | Current Value |
| Unit of Mass.PK_UNIT_MASS |
| Entity Name | Unit of Mass |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Unit of Mass.PK_UNIT_MASS Index Columns |
| ColumnName | Sort Order |
| Mass Unit Identifier |
| Unit of Mass.PK_UNIT_MASS Bound Attachments |
| Name | Current Value |
| Unit of Pressure.PK_UNIT_OF_PRESS |
| Entity Name | Unit of Pressure |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Unit of Pressure.PK_UNIT_OF_PRESS Index Columns |
| ColumnName | Sort Order |
| Pressure Unit Identifier |
| Unit of Pressure.PK_UNIT_OF_PRESS Bound Attachments |
| Name | Current Value |
| Unit of Temperature.PK_UNIT_TEMP |
| Entity Name | Unit of Temperature |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Unit of Temperature.PK_UNIT_TEMP Index Columns |
| ColumnName | Sort Order |
| Temperature Unit Identifier |
| Unit of Temperature.PK_UNIT_TEMP Bound Attachments |
| Name | Current Value |
| User Profile.PK_USER_PROFILE |
| Entity Name | User Profile |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| User Profile.PK_USER_PROFILE Index Columns |
| ColumnName | Sort Order |
| Person Identifier |
| User Profile.PK_USER_PROFILE Bound Attachments |
| Name | Current Value |
| User Publication.PK_USER_PUBL |
| Entity Name | User Publication |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| User Publication.PK_USER_PUBL Index Columns |
| ColumnName | Sort Order |
| Person Identifier | |
| Proposal Identifier |
| User Publication.PK_USER_PUBL Bound Attachments |
| Name | Current Value |
| Validated Experiment Team Member.PK_VAL_EXPT_TEAM_MBR |
| Entity Name | Validated Experiment Team Member |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Validated Experiment Team Member.PK_VAL_EXPT_TEAM_MBR Index Columns |
| ColumnName | Sort Order |
| Proposal Identifier | |
| Submission Number | |
| Person Identifier |
| Validated Experiment Team Member.PK_VAL_EXPT_TEAM_MBR Bound Attachments |
| Name | Current Value |
| Validated Experiment Team Member.FK_VAL_EXPT_TM_INST |
| Entity Name | Validated Experiment Team Member |
| Logical Only | NO |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| Key Type | Inversion Entry |
| Validated Experiment Team Member.FK_VAL_EXPT_TM_INST Index Columns |
| ColumnName | Sort Order |
| INST_ID |
| Validated Experiment Team Member.FK_VAL_EXPT_TM_INST Bound Attachments |
| Name | Current Value |
| Validated Experiment Team Member.FK_VAL_EXPT_TM_PERSON |
| Entity Name | Validated Experiment Team Member |
| Logical Only | NO |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| Key Type | Inversion Entry |
| Validated Experiment Team Member.FK_VAL_EXPT_TM_PERSON Index Columns |
| ColumnName | Sort Order |
| Person Identifier |
| Validated Experiment Team Member.FK_VAL_EXPT_TM_PERSON Bound Attachments |
| Name | Current Value |
| Validated Experiment Team Member.VAL_EXPT_TEAM_MBR_IND1 |
| Entity Name | Validated Experiment Team Member |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | Alternate Key |
| Validated Experiment Team Member.VAL_EXPT_TEAM_MBR_IND1 Index Columns |
| ColumnName | Sort Order |
| Person Identifier | |
| Member Role Identifier |
| Validated Experiment Team Member.VAL_EXPT_TEAM_MBR_IND1 Bound Attachments |
| Name | Current Value |
| Workflow.PK_WORKFLOW |
| Entity Name | Workflow |
| Logical Only | NO |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| Key Type | PrimaryKey |
| Workflow.PK_WORKFLOW Index Columns |
| ColumnName | Sort Order |
| WorkFlow Identifier |
| Workflow.PK_WORKFLOW Bound Attachments |
| Name | Current Value |