Table openpetra_trunk.public.pm_year_program_application
This table contains information pertaining to the application process.

 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
pm_general_application.p_partner_key_n pm_year_program_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
pm_general_application.pm_application_key_i pm_year_program_application_fk1 R
Key to uniquely identify application
pm_registration_office_n numeric 10 0
pm_general_application.pm_registration_office_n pm_year_program_application_fk1 R
Partner key of office by which application was entered.
pm_yp_app_date_d date 13 Date of application
pm_yp_basic_app_type_c varchar 32 Describes what the application is for, eg. conference, year program.
pm_yp_basic_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_yp_app_fee_received_l bool 1  √  false Indicates if the application fee has been paid.
pm_ho_orient_conf_booking_key_c varchar 16  √  null Indicates booking at an orientation session.
pm_yp_agreed_support_figure_n numeric 24,10  √  0 The agreed support figure.
pm_yp_agreed_joining_charge_n numeric 24,10  √  0 Indicates the agreed upon joining charge for the conference and / or the summer outreach.
pm_yp_scholarship_n numeric 24,10  √  0 Enter the amount of the scholarship.
pm_yp_scholarship_athrized_by_c varchar 40  √  null Indicate who authorized the scholarship.
pm_yp_scholarship_begin_date_d date 13  √  null Indicates the begin date for the scholarship.
pm_yp_scholarship_end_date_d date 13  √  null Indicates the end date for the scholarship.
pm_yp_scholarship_review_date_d date 13  √  null Indicates the date of the review of the scholarship.
pm_yp_scholarship_period_c varchar 24  √  null Length of time the scholarship period covers.
pm_yp_support_period_c varchar 24  √  null Period of time the support covers..
pm_yp_joining_conf_i int4 10  √  1 Indicates which New Recruits Conference the applicant plans to attend.
pm_start_of_commitment_d date 13  √  null This is the expected date their commitment starts.
pm_end_of_commitment_d date 13  √  null This is the expected date their commitment ends.
pm_intended_com_length_months_i int4 10  √  null Indicates how long the applicant intends to stay with us
pt_position_name_c varchar 60  √  null
pt_position.pt_position_name_c pm_year_program_application_fk2 R
Name of the position.
pt_position_scope_c varchar 24  √  null
pt_position.pt_position_scope_c pm_year_program_application_fk2 R
Scope of this position.
pt_assistant_to_l bool 1  √  false Indicates if the assignment is in assistance to the given position.
s_date_created_d date 13  √  ('now'::text)::date
s_created_by_c varchar 20  √  null
s_user.s_user_id_c pm_year_program_application_fkcr R
s_date_modified_d date 13  √  null
s_modified_by_c varchar 20  √  null
s_user.s_user_id_c pm_year_program_application_fkmd R
s_modification_id_c varchar 150  √  null

Table contained 110 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_year_program_application_pk
pt_position_name_c + pt_position_scope_c Performance Asc/Asc inx__program_application_fk2_key1
p_partner_key_n + pm_yp_app_date_d + pm_yp_basic_app_type_c Must be unique Asc/Asc/Asc inx__year_program_application_nk0
p_partner_key_n + pm_application_key_i + pm_registration_office_n Must be unique Asc/Asc/Asc inx__year_program_application_pk0
s_created_by_c Performance Asc inx_program_application_fkcr_key2
s_modified_by_c Performance Asc inx_program_application_fkmd_key3
p_partner_key_n + pm_yp_app_date_d + pm_yp_basic_app_type_c Must be unique Asc/Asc/Asc pm_year_program_application_nk
p_partner_key_n Performance Asc ypa_partner_k1

Close relationships  within of separation: