| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| p_partner_key_n |
numeric |
10 |
|
|
0 |
|
| p_person.p_partner_key_n
|
pm_long_term_support_figures_fk1 R |
|
| pm_record_number_i |
int4 |
10 |
|
|
0 |
|
|
| pm_allowance_n |
numeric |
24,10 |
√ |
|
0 |
|
|
| pm_period_c |
varchar |
24 |
|
|
|
|
|
| a_currency_code_c |
varchar |
16 |
|
|
|
|
|
| pm_admin_grant_n |
numeric |
24,10 |
√ |
|
0 |
|
|
| pm_housing_n |
numeric |
24,10 |
√ |
|
0 |
|
|
| pm_vehicle_n |
numeric |
24,10 |
√ |
|
0 |
|
|
| pm_food_n |
numeric |
24,10 |
√ |
|
0 |
|
|
| pm_travel_conferences_n |
numeric |
24,10 |
√ |
|
0 |
|
|
| pm_insurance_n |
numeric |
24,10 |
√ |
|
0 |
|
|
| pm_pension_n |
numeric |
24,10 |
√ |
|
0 |
|
|
| pm_childrens_education_n |
numeric |
24,10 |
√ |
|
0 |
|
|
| pm_home_assignment_holiday_n |
numeric |
24,10 |
√ |
|
0 |
|
|
| pm_medical_dental_care_n |
numeric |
24,10 |
√ |
|
0 |
|
|
| pm_postage_telephone_n |
numeric |
24,10 |
√ |
|
0 |
|
|
| pm_study_training_n |
numeric |
24,10 |
√ |
|
0 |
|
|
| pm_ministry_costs_n |
numeric |
24,10 |
√ |
|
0 |
|
|
| pm_personal_n |
numeric |
24,10 |
√ |
|
0 |
|
|
| pm_other_n |
numeric |
24,10 |
√ |
|
0 |
|
|
| pm_extra_cost1_label_c |
varchar |
50 |
|
|
|
|
|
| pm_extra_cost1_n |
numeric |
24,10 |
√ |
|
0 |
|
|
| pm_extra_cost2_label_c |
varchar |
50 |
|
|
|
|
|
| pm_extra_cost2_n |
numeric |
24,10 |
√ |
|
0 |
|
|
| pm_extra_cost3_label_c |
varchar |
50 |
|
|
|
|
|
| pm_extra_cost3_n |
numeric |
24,10 |
√ |
|
0 |
|
|
| pm_actual_support_figure_n |
numeric |
24,10 |
√ |
|
0 |
|
|
| pm_agreed_support_figure_n |
numeric |
24,10 |
√ |
|
0 |
|
|
| pm_agreement_date_d |
date |
13 |
√ |
|
null |
|
|
| pm_review_date_d |
date |
13 |
√ |
|
null |
|
|
| s_date_created_d |
date |
13 |
√ |
|
('now'::text)::date |
|
|
| s_created_by_c |
varchar |
20 |
√ |
|
null |
|
| s_user.s_user_id_c
|
pm_long_term_support_figures_fkcr R |
|
| s_date_modified_d |
date |
13 |
√ |
|
null |
|
|
| s_modified_by_c |
varchar |
20 |
√ |
|
null |
|
| s_user.s_user_id_c
|
pm_long_term_support_figures_fkmd R |
|
| s_modification_id_c |
varchar |
150 |
√ |
|
null |
|
|
Table contained 0 rows at Mi Nov 09 18:02 MEZ 2011
|
