Table pm_short_term_application

Description:
Table for short term applications.

PRIMARY KEY
p_partner_key_n bigint default: 0 NOT NULL	This is the partner key assigned to each partner. It consists of the fund id followed by a computer generated six digit number.	pm_general_application
pm_application_key_i integer default: 0 NOT NULL	Key to uniquely identify application	pm_general_application
pm_registration_office_n bigint default: 0 NOT NULL	Partner key of office by which application was entered.	pm_general_application

UNIQUE KEY
p_partner_key_n bigint default: 0 NOT NULL	This is the partner key assigned to each partner. It consists of the fund id followed by a computer generated six digit number.	pm_general_application
pm_st_app_date_d date NOT NULL	Date of application
pm_st_application_type_c varchar (32) NOT NULL
pm_st_basic_outreach_id_c varchar (32) NOT NULL	TODO: this field is a combination of registration office and application number. might not be needed???

pm_st_basic_delete_flag_l boolean default: '0'	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_st_application_on_hold_l boolean default: '0'	Indicates if the application is on hold.
pm_st_application_hold_reason_c varchar (40)	Comment on why the application is on hold.
pm_confirmed_option_code_c varchar (26)	Indicates the outreach code of the confirmed option.
pm_st_outreach_only_flag_l boolean default: '0'	Indicates if for outreach only.
pm_st_confirmed_option_n bigint	Indicates the confirmed outreach option.	p_unit
pm_st_current_field_n bigint	Indicates the current field.	p_unit
pm_arrival_details_status_c varchar (24) default: 'no'	Indicates the status of given arrival details (not known, being planned,...).
pt_arrival_point_code_c varchar (32)	This code indicates the arrival point of the congress attendee.	pt_arrival_point
pt_travel_type_to_cong_code_c varchar (32)	This code indicates the type of travel to the congress..	pt_travel_type
pm_arrival_d date	Date of arrival at the conference.
pm_arrival_hour_i integer default: 00	The hour of arrival.
pm_arrival_minute_i integer default: 00	The minutes of arrival.
pm_to_cong_travel_info_c varchar (32)	Information concerning flight or bus numbers.
pm_arrival_transport_needed_l boolean default: '0'	Indicates if transport from arrival point to congress needs to be arranged by Registrar.
pm_arrival_comments_c varchar (160)	Gives further comments on arrival information.
pm_departure_details_status_c varchar (24) default: 'no'	Indicates the status of given departure details (undetermined, being planned,...).
pt_departure_point_code_c varchar (32)	This code indicates the departure point of the congress attendee.	pt_arrival_point
pt_travel_type_from_cong_code_c varchar (32)	This code indicates the type of travel from the congress.	pt_travel_type
pm_departure_d date	Date of departure from the conference.
pm_departure_hour_i integer default: 00	The hour of departure.
pm_departure_minute_i integer default: 00	The minutes of departure.
pm_from_cong_travel_info_c varchar (32)	Information concerning flight or bus numbers.
pm_departure_transport_needed_l boolean default: '0'	Indicates if transport from congress to departure point needs to be arranged by Registrar.
pm_departure_comments_c varchar (160)	Gives further comments on departure information.
pm_transport_interest_l boolean default: '0'	Applicant is interested if there would be a transport possibility from/to arrival/departure point.
pm_st_pre_congress_code_c varchar (32)	This code indicates what role they have during pre-congress.	pt_congress_code
pm_st_congress_code_c varchar (32)	Indicates the role for the Congress.	pt_congress_code
pm_st_special_applicant_c varchar (32)	Indicates any special information about the applicant.	pt_special_applicant
pm_outreach_role_c varchar (32)	The role a participant has during a outreach	pt_congress_code
pm_st_fg_leader_l boolean default: '0'	Indicates if the person is a leader of a fellowship group.
pm_st_fg_code_c varchar (32)	A free form field for group codes.
pm_st_outreach_special_cost_i integer default: 0	Special Costs related to the outreach.
pm_st_cngrss_special_cost_i integer default: 0	Special Costs related to the congress.
pm_st_field_charged_n bigint	This field idenifies the field to be charged for the costs.	p_unit
pm_st_congress_language_c varchar (20)	This is the language spoken by the applicant at the Congress.	p_language
s_date_created_d date default: CURRENT_DATE	The date the record was created.
s_created_by_c varchar (20)	User ID of who created this record.	s_user
s_date_modified_d date	The date the record was modified.
s_modified_by_c varchar (20)	User ID of who last modified this record.	s_user
s_modification_id_t timestamp default: CURRENT_TIMESTAMP	This identifies the current version of the record.
FOREIGN KEY pm_short_term_application_fk1: p_partner_key_n;pm_application_key_i;pm_registration_office_n => pm_general_application pm_short_term_application_fk2: pm_st_special_applicant_c => pt_special_applicant pm_short_term_application_fk3: pt_arrival_point_code_c => pt_arrival_point pm_short_term_application_fk4: pt_departure_point_code_c => pt_arrival_point pm_short_term_application_fk5: pt_travel_type_to_cong_code_c => pt_travel_type pm_short_term_application_fk6: pt_travel_type_from_cong_code_c => pt_travel_type pm_short_term_application_fk7: pm_st_pre_congress_code_c => pt_congress_code pm_short_term_application_fk8: pm_st_congress_code_c => pt_congress_code pm_short_term_application_fk9: pm_outreach_role_c => pt_congress_code pm_short_term_application_fk10: pm_st_congress_language_c => p_language pm_short_term_application_fk11: pm_st_confirmed_option_n => p_unit pm_short_term_application_fk12: pm_st_current_field_n => p_unit pm_short_term_application_fk13: pm_st_field_charged_n => p_unit pm_short_term_application_fkcr: s_created_by_c => s_user pm_short_term_application_fkmd: s_modified_by_c => s_user