Table openpetra_trunk.public.pm_general_application
The first part of any application which contains data common to either short term or long term applications.

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
p_partner_key_n numeric 10 0
p_data_label_value_application.p_partner_key_n p_data_label_value_application_fk1 R
pm_application_file.p_partner_key_n pm_application_file_fk2 R
pm_application_forms.p_partner_key_n pm_application_forms_fk1 R
pm_application_status_history.p_partner_key_n pm_application_status_history_fk1 R
pm_short_term_application.p_partner_key_n pm_short_term_application_fk1 R
pm_year_program_application.p_partner_key_n pm_year_program_application_fk1 R
p_person.p_partner_key_n pm_general_application_fk1 R
This is the partner key assigned to each partner. It consists of the fund id followed by a computer generated six digit number.
pm_application_key_i int4 10 0
p_data_label_value_application.pm_application_key_i p_data_label_value_application_fk1 R
pm_application_file.pm_application_key_i pm_application_file_fk2 R
pm_application_forms.pm_application_key_i pm_application_forms_fk1 R
pm_application_status_history.pm_application_key_i pm_application_status_history_fk1 R
pm_short_term_application.pm_application_key_i pm_short_term_application_fk1 R
pm_year_program_application.pm_application_key_i pm_year_program_application_fk1 R
Key to uniquely identify application
pm_registration_office_n numeric 10 0
p_data_label_value_application.pm_registration_office_n p_data_label_value_application_fk1 R
pm_application_file.pm_registration_office_n pm_application_file_fk2 R
pm_application_forms.pm_registration_office_n pm_application_forms_fk1 R
pm_application_status_history.pm_registration_office_n pm_application_status_history_fk1 R
pm_short_term_application.pm_registration_office_n pm_short_term_application_fk1 R
pm_year_program_application.pm_registration_office_n pm_year_program_application_fk1 R
p_unit.p_partner_key_n pm_general_application_fk2 R
Partner key of office by which application was entered.
pm_gen_app_date_d date 13 Date of application.
pt_app_type_name_c varchar 32
pt_application_type.pt_app_type_name_c pm_general_application_fk5 R
Describes what the application is for, eg. conference, year program.
pm_old_link_c varchar 32 TODO: this field is a combination of registration office and application number. might not be needed???
pm_gen_app_poss_srv_unit_key_n numeric 10  √  null
p_unit.p_partner_key_n pm_general_application_fk3 R
This is the possible field or team of service.
pm_gen_app_delete_flag_l bool 1  √  false This field will not appear on the screen but will be updated when someone chooses to delete a record. Rather that an actual deletion, the record will be 'marked' for deletion after an agreed upon interval.
pm_gen_applicant_type_c varchar 30 Describes the applicant, eg. volunteer, staff, speaker.
pm_gen_application_status_c varchar 32  √  null
pt_applicant_status.pt_code_c pm_general_application_fk4 R
Indicates the status of the application.
pm_closed_l bool 1  √  false Indicates if the application is closed.
pm_closed_by_c varchar 20  √  null
s_user.s_user_id_c pm_general_application_fk10 R
This identifies the user that closed the application
pm_date_closed_d date 13  √  null This is the date the application was closed.
pm_gen_application_on_hold_l bool 1  √  false Indicates if the application is on hold.
pm_gen_application_hold_reason_c varchar 100  √  null Comment on why the application is on hold.
pm_gen_cancelled_app_l bool 1  √  false Indicates if the application process has been cancelled.
pm_gen_app_cancel_reason_c varchar 54  √  null Comment on why the application is on hold.
pm_gen_app_cancelled_d date 13  √  null This is the date the application was cancelled.
pm_gen_app_srv_fld_accept_l bool 1  √  false Describes if the applicant has been accepted by the serving field.
pm_gen_app_recvg_fld_accept_d date 13  √  null This is the date the receiving field accepted the applicant.
pm_gen_app_send_fld_accept_l bool 1  √  false Describes if the applicant has been accepted by the sending field.
pm_gen_app_send_fld_accept_d date 13  √  null This is the date the sending field accepted the applicant.
pm_gen_contact1_c varchar 40  √  null This field indicates how they were influenced to apply with us.
pm_gen_contact2_c varchar 40  √  null This field indicates how they were influenced to apply with us.
pm_gen_app_update_d date 13  √  null Indicates the date the record was last updated.
pm_gen_year_program_c varchar 2  √  null Indicates if the person may consider joining the year program.
pm_comment_c varchar 2000  √  null Sometimes there are extra comments of preferences that are related to an application. These can be entered here.
pm_gen_app_currency_code_c varchar 16  √  null
a_currency.a_currency_code_c pm_general_application_fk8 R
This is the currency that is used for amounts listed in this application
pm_placement_partner_key_n numeric 10  √  null
p_person.p_partner_key_n pm_general_application_fk9 R
This is the placement person handling this application.
pm_raw_application_data_c varchar 30000  √  null stores the plain data received from the browser in JSON format
p_local_partner_key_n numeric 10  √  null the person partner key of the applicant in the local database of the registration office. no foreign key since the person partner is in another database
p_imported_local_petra_l bool 1  √  false true if the applicant has already been imported into the local database of the registration office.
s_date_created_d date 13  √  ('now'::text)::date
s_created_by_c varchar 20  √  null
s_user.s_user_id_c pm_general_application_fkcr R
s_date_modified_d date 13  √  null
s_modified_by_c varchar 20  √  null
s_user.s_user_id_c pm_general_application_fkmd R
s_modification_id_c varchar 150  √  null

Table contained 24.790 rows at Do Nov 10 18:00 MEZ 2011

Indexes:
Column(s) Type Sort Constraint Name
p_partner_key_n + pm_application_key_i + pm_registration_office_n Primary key Asc/Asc/Asc pm_general_application_pk
p_partner_key_n Performance Asc inx__general_application_fk1_key1
pm_registration_office_n Performance Asc inx__general_application_fk2_key2
pm_gen_app_poss_srv_unit_key_n Performance Asc inx__general_application_fk3_key3
pm_gen_application_status_c Performance Asc inx__general_application_fk4_key4
pt_app_type_name_c Performance Asc inx__general_application_fk5_key5
pm_gen_contact1_c Performance Asc inx__general_application_fk6_key6
pm_gen_contact2_c Performance Asc inx__general_application_fk7_key7
pm_gen_app_currency_code_c Performance Asc inx__general_application_fk8_key8
pm_placement_partner_key_n Performance Asc inx__general_application_fk9_key9
pm_closed_by_c Performance Asc inx_general_application_fk10_key10
s_created_by_c Performance Asc inx_general_application_fkcr_key11
s_modified_by_c Performance Asc inx_general_application_fkmd_key12
p_partner_key_n + pm_gen_app_date_d + pt_app_type_name_c + pm_old_link_c Must be unique Asc/Asc/Asc/Asc inx_pm_general_application_nk0
p_partner_key_n + pm_application_key_i + pm_registration_office_n Must be unique Asc/Asc/Asc inx_pm_general_application_pk0
p_partner_key_n + pm_gen_app_date_d + pt_app_type_name_c + pm_old_link_c Must be unique Asc/Asc/Asc/Asc pm_general_application_nk

Close relationships  within of separation: