| Top of PRZ | Index | Table of Contents | Feedback | |
Prizes Letter Extract
To view PRZJ0030 - see the associated view of s_extract, see directly below. To view the Letter Record Type Definition (s_extract_record), select here
To view PRZJ0040 - see the associated view of s_extract here. To view the Letter Record Type Definition (s_extract_record), select here.
(Associated view: PRZ_RCPNT_NTFCTN_EXTRACT_V) - PRZJ0030
Field Name |
Field Description |
Data Source |
S_EXTRACT_TYPE |
The Extact Type |
PRZ-RCP-LT |
CREATION_DT |
The Creation Date Of The Extract |
SYSDATE |
KEY |
The key created from the passed in the job parameters |
p_correspondence_type |
REQUEST_JOB_RUN_ID |
The Request Job Run ID of the job passed as a parameter |
p_request_job_run_id |
(Associated view: PRZ_DNR_NTFCTN_EXTRACT_V) - PRZJ0040
Field Name |
Field Description |
Data Source |
S_EXTRACT_TYPE |
The Extract Type |
PRZ-DNR-LT |
CREATION_DT |
The Creation Date Of The Extract |
SYSDATE |
KEY |
The key created from the passed in the job parameters |
p_correspondence_type |
REQUEST_JOB_RUN_ID |
The Request Job Run ID of the job passed as a parameter |
p_request_job_run_id |
PRZJ0030 - The s_extract_record is broken down into the following sections (See here for PRZJ0040):
Field Name |
Field Description |
Max Length |
Type |
Source / Value |
CREATION_DT – CREATION DATE |
The creation date of the extract |
. |
date |
SYSDATE |
PRIZE_YR KEY1 |
The Prize Year |
4 |
Number |
to_date(cal_instance.start_dt, ‘YYYY’) in context of acad_cal_type and acad_ci_sequence_number parameters |
KEY2 - 9 |
. |
. |
Blank |
. |
RECORD TYPE - RECORD_TYPE |
Record Type |
20 |
char |
'HEADER' |
FIELD1 |
The Correspondence Type |
10 |
char |
p_correspondence_type |
FIELD2 |
Person ID |
10 |
Number |
p_person_id |
FIELD3 |
The person id group id |
10 |
Number |
p_person_id_group_id |
FIELD4 |
The Prize Year Calendar Type |
10 |
char |
p_cal_type |
FIELD5 |
The Prize Year Sequence Number |
6 |
number |
p_ci_sequence_number |
FIELD6 |
The Prize Code |
10 |
char |
p_prize_cd |
FIELD7 |
The Person Prize Status |
10 |
char |
p_person_prize_status |
FIELD8 |
The Donor Code |
10 |
char |
p_donor_cd |
FIELD9 |
The Donor Address Type |
10 |
char |
p_dnr_addr_type |
FIELD10 |
The Prize Responsible Organisational Unit |
10 |
char |
p_org_unit_cd |
FIELD11 |
The Prize Responsible Organisational Unit Start Date |
. |
date |
p_ou_start_dt |
FIELD12 |
Address Type |
10 |
char |
institution_addr.addr_type |
FIELD13 |
Address Line 1 |
40 |
char |
institution.addr_line_1 |
FIELD14 |
Address Line 2 |
40 |
char |
institution_addr.addr_line_2 |
FIELD15 |
Address Line 3 |
40 |
char |
institution_addr.addr_line_3 |
FIELD16 |
Address Line 4 |
40 |
char |
institution_addr.addr_line_4 |
FIELD17 |
Address Line 5 |
40 |
char |
institution_addr.addr_line_5 |
FIELD18 |
Australian Postcode |
4 |
number |
institution_addr.aust_postcode |
FIELD19 |
Overseas Code |
10 |
char |
institution_addr.os_code |
FIELD20 |
Phone 1 |
20 |
char |
institution_addr.phone_1 |
FIELD21 |
Phone 2 |
20 |
char |
institution_addr.phone_2 |
FIELD22 |
Phone 3 |
20 |
char |
institution_addr.phone_3 |
FIELD23 |
Other Details |
40 |
char |
institution_addr.other_details |
FIELD24 |
NULL |
. |
. |
. |
Field Name |
Field Description |
Max Length |
Type |
Source / Value |
CREATION_DT – CREATION DATE |
The creation date of the extract |
. |
date |
SYSDATE |
PRIZE_YR |
The Prize Year |
4 |
Number |
to_date(cal_instance.start_dt, ‘YYYY’) in context of acad_cal_type and acad_ci_sequence_number parameters |
PERSON_ID |
The Student ID |
10 |
num |
person.person_id |
–SURNAME |
The Student's Surname |
30 |
char |
person.surname |
GIVEN_NAMES |
The Student's Given Name/s |
40 |
char |
person.given_names |
RECORD TYPE - RECORD_TYPE |
Record Type |
20 |
char |
'PERSON' |
FIELD1 |
The Student ID |
10 |
num |
person.person_id |
FIELD2 |
The Student’s Surname |
30 |
char |
person.surname |
FIELD3 |
The Student's Given Name/s |
40 |
char |
person.given_names |
FIELD4 |
The Student’s Title |
10 |
char |
person.title |
FIELD5 – 22 |
NULL |
. |
. |
. |
Field Name |
Field Description |
Max Length |
Type |
Source / Value |
|
CREATION_DT – CREATION DATE |
The creation date of the extract |
. |
date |
SYSDATE |
|
PRIZE_YR KEY1 |
The Prize Year |
4 |
Number |
to_date(cal_instance.start_dt, ‘YYYY’) in context of acad_cal_type and acad_ci_sequence_number parameters |
|
PERSON_ID |
The Student ID |
10 |
num |
person.person_id |
|
SURNAME |
The Student's Surname |
30 |
char |
person.surname |
|
GIVEN_NAMES |
The Student's Given Name/s |
40 |
char |
person.given_names |
|
RECORD TYPE - RECORD_TYPE |
Record Type |
20 |
char |
'ADDRESS' |
|
FIELD1 |
Address Line 1 |
40 |
char |
Current Correspondence Address |
|
FIELD2 |
Address Line 2 |
40 |
char |
person_address.addr_line_2 |
|
FIELD3 |
Address Line 3 |
40 |
char |
person_address.addr_line_3 |
|
FIELD4 |
Address Line 4 |
40 |
char |
person_address.addr_line_4 |
|
FIELD5 |
Address Line 5 |
40 |
char |
person_address.addr_line_5 |
|
FIELD6 |
Australian Postcode |
4 |
num |
person_address.aust_postcode |
|
FIELD7 |
Overseas Postcode |
10 |
char |
person_addr.os_code |
|
FIELD8 |
Address Type |
10 |
char |
person_addr.addr_type |
|
FIELD9 |
Start Date |
. |
date |
person_addr.start_dt |
|
FIELD10 |
End Date |
. |
date |
person_addr.end_dt |
|
FIELD11 – 22 |
NULL |
. |
. |
. |
|
Field Name |
Field Description |
Max Length |
Type |
Source / Value |
CREATION_DT – CREATION DATE |
The creation date of the extract |
. |
date |
SYSDATE |
KEY5 –PRIZE_YR |
The Prize Year |
4 |
number |
to_date(cal_instance.start_dt, ‘YYYY’) in context of acad_cal_type and acad_ci_sequence_number parameters |
PERSON_ID |
The Student ID |
10 |
num |
person.person_id |
SURNAME |
The Student's Surname |
30 |
char |
person.surname |
GIVEN_NAMES |
The Student's Given Name/s |
40 |
char |
person.given_names |
PRIZE_CD |
The Prize Code |
10 |
char |
person_prize.prize_cd |
RECORD TYPE - RECORD_TYPE |
Record Type |
20 |
char |
‘PRIZE-DETAILS’ |
FIELD1 |
Prize Name |
60 |
char |
prize_detail.prize_name |
FIELD2 |
Prize Criteria |
240 |
char |
If set use person_prize.override_cor_criteria else use prize_criteria.cor_criteria effective at the Prize Date Alias Instance date value |
FIELD5 |
Prize Year |
4 |
number |
to_date(cal_instance.start_dt, ‘YYYY’) in context of acad_cal_type and acad_ci_sequence_number parameters |
FIELD6 |
Award Date |
. |
date |
person_prize.award_date |
FIELD7 - 22 |
NULL |
. |
. |
. |
Field Name |
Field Description |
Max Length |
Type |
Source / Value |
CREATION_DT – CREATION DATE |
The creation date of the extract |
. |
date |
SYSDATE |
PRIZE_YR |
The Prize Year |
4 |
number |
to_date(cal_instance.start_dt, ‘YYYY’) in context of acad_cal_type and acad_ci_sequence_number parameters |
PERSON_ID |
The Student ID |
10 |
num |
person.person_id |
SURNAME |
The Student's Surname |
30 |
char |
person.surname |
GIVEN_NAMES |
The Student's Given Name/s |
40 |
char |
person.given_names |
PRIZE_CD |
The Prize Code |
10 |
char |
person_prize.prize_cd |
RECORD TYPE - RECORD_TYPE |
Record Type |
20 |
char |
‘PRIZE-DETAIL-TYPE’ |
FIELD1 |
The Prize Code |
10 |
char |
person_prize.prize_cd |
FIELD2 |
Prize Type |
19 |
char |
prize_type.prize_type |
FIELD3 |
The Prize Detail Type Start Date |
. |
date |
prize_detail_type.start_dt |
FIELD4 |
The Prize Detail Type End Date |
. |
date |
prize_detail_type.start_dt |
FIELD5 |
Prize Value |
240 |
char |
If set: |
FIELD6 – 22 |
NULL |
. |
. |
. |
Field Name |
Field Description |
Max Length |
Type |
Source / Value |
CREATION_DT – CREATION DATE |
The creation date of the extract |
. |
date |
SYSDATE |
PRIZE_YR |
The Prize Year |
4 |
number |
to_date(cal_instance.start_dt, ‘YYYY’) in context of acad_cal_type and acad_ci_sequence_number parameters |
PERSON_ID |
The Student ID |
10 |
num |
person.person_id |
SURNAME |
The Student's Surname |
30 |
char |
person.surname |
GIVEN_NAMES |
The Student's Given Name/s |
40 |
char |
person.given_names |
PRIZE_CD |
The Prize Code |
10 |
char |
person_prize.prize_cd |
RECORD TYPE - RECORD_TYPE |
Record Type |
20 |
char |
‘PRIZE-RESPONSIBILITY’ |
FIELD1 |
The Prize Code |
10 |
char |
prize_responsibility.prize_cd |
FIELD2 |
The Org Unit Code |
10 |
char |
prize_responsibility.org_unit_cd |
FIELD3 |
The Org Unit Start Date |
. |
date |
prize_responsibility.ou_start_dt |
FIELD4 |
The Primary Indicator |
1 |
char |
prize_responsibility.primary_ind |
FIELD5 – 22 |
NULL |
. |
. |
. |
Field Name |
Field Description |
Max Length |
Type |
Source / Value |
CREATION_DT – CREATION DATE |
The creation date of the extract |
. |
date |
SYSDATE |
PRIZE_YR |
The Prize Year |
4 |
number |
to_date(cal_instance.start_dt, ‘YYYY’) in context of acad_cal_type and acad_ci_sequence_number parameters |
PERSON_ID |
The Student ID |
10 |
num |
person.person_id |
–SURNAME |
The Student's Surname |
30 |
char |
person.surname |
GIVEN_NAMES |
The Student's Given Name/s |
40 |
char |
person.given_names |
PRIZE_CD |
The Prize Code |
10 |
char |
person_prize.prize_cd |
RECORD TYPE - RECORD_TYPE |
Record Type |
20 |
char |
‘DONOR-DETAILS’ |
FIELD1 |
Donor Anonymity Indicator |
1 |
char |
donor.anonymity_ind |
FIELD2 |
Donor Code |
10 |
char |
prize_donor.donor_cd |
FIELD3 |
Donor Person ID/Donor Org Unit Code |
10 |
num/char |
Retrieve person_id or org_unit_cd from donor table – validation ensures one and only one willl exist, not both |
FIELD4 |
Donor Name |
82/60 |
char |
person_display_v.title_name/org_ unit.description |
FIELD5 |
Address Line 1 |
40 |
char |
Passed in Donor Address Ttype |
FIELD6 |
Address Line 1 |
40 |
char |
person_addres/org_addr.addr_line_2 |
FIELD7 |
Address Line 1 |
40 |
char |
person_addres/org_addr.addr_line_3 |
FIELD8 |
Address Line 1 |
40 |
char |
person_addres/org_addr.addr_line_4 |
FIELD9 |
Address Line 1 |
40 |
char |
person_addres/org_addr.addr_line_5 |
FIELD10 |
Australian Postcode |
4 |
num |
person_address/org_addr.aust_postcode |
FIELD11 |
Overseas Postcode |
10 |
char |
person_addr/org_addr.os_code |
FIELD12 |
Address Type |
10 |
char |
person_addr/org_addr.addr_type |
FIELD13 |
Start Date |
. |
date |
person_addr/org_addr.start_dt |
FIELD14 |
End Date |
. |
date |
person_addr/org_addr.end_dt |
FIELD15 - 22 |
. |
. |
. |
. |
Field Name |
Field Description |
Max Length |
Type |
Source / Value |
CREATION_DT – CREATION DATE |
The creation date of the extract |
. |
date |
SYSDATE |
PRIZE_YR |
The Prize Year |
4 |
Number |
to_date(cal_instance.start_dt, ‘YYYY’) in context of acad_cal_type and acad_ci_sequence_number parameters |
KEY2 - 9 |
. |
. |
Blank |
. |
RECORD TYPE - RECORD_TYPE |
Record Type |
20 |
char |
'FOOTER' |
FIELD1 |
Count or record type PERSON |
6 |
number |
calculated |
FIELD2 |
Count of record type ADDRESS |
6 |
number |
calculated |
FIELD3 |
Count of record type PRIZE-DETAILS |
6 |
number |
calculated |
FIELD4 |
Count of record type PRIZE-DETAIL-TYPE |
6 |
number |
calculated |
FIELD5 |
Count of record type PRIZE-RESPONSIBILITY |
6 |
Number |
calculated |
FIELD6 |
Count of record type DONOR-DETAILS |
6 |
Number |
Calculated |
FIELD7 – 22 |
NULL |
. |
. |
. |
PRZJ0040 - The s_extract_record is broken down into the following sections
Field Name |
Field Description |
Max Length |
Type |
Source / Value |
CREATION_DT – CREATION DATE |
The creation date of the extract |
. |
Date |
SYSDATE |
PRIZE_YR |
The Prize Year |
10 |
Char |
Nvl (ci.alternate_code, ci.cal_type) |
CORRESPONDENCE_TYPE |
The correspondence type |
10 |
Char |
Correspondence.correspondence_type |
KEY3 - 9 |
. |
. |
Blank |
. |
RECORD TYPE - RECORD_TYPE |
Record Type |
20 |
char |
'HEADER' |
FIELD1 |
The Correspondence Type |
10 |
char |
p_correspondence_type |
FIELD2 |
The Prize Year Calendar Type |
10 |
char |
p_cal_type |
FIELD3 |
The Prize Year Sequence Number |
6 |
number |
p_ci_sequence_number |
FIELD4 |
The Prize Code |
10 |
char |
p_prize_cd |
FIELD5 |
The Person Prize Status |
10 |
char |
p_person_prize_status |
FIELD6 |
The Donor Code |
10 |
char |
p_donor_cd |
FIELD7 |
The Donor Address Type |
10 |
char |
p_dnr_addr_type |
FIELD8 |
The Prize Responsible Organisational Unit |
10 |
char |
p_org_unit_cd |
FIELD9 |
The Prize Responsible Organisational Unit Start Date |
. |
date |
p_ou_start_dt |
FIELD10 |
Address Type |
10 |
char |
institution_addr.addr_type |
FIELD11 |
Address Line 1 |
40 |
char |
institution.addr_line_1 |
FIELD12 |
Address Line 2 |
40 |
char |
institution_addr.addr_line_2 |
FIELD13 |
Address Line 3 |
40 |
char |
institution_addr.addr_line_3 |
FIELD14 |
Address Line 4 |
40 |
char |
institution_addr.addr_line_4 |
FIELD15 |
Address Line 5 |
40 |
char |
institution_addr.addr_line_5 |
FIELD16 |
Australian Postcode |
4 |
number |
institution_addr.aust_postcode |
FIELD17 |
Overseas Code |
10 |
char |
institution_addr.os_code |
FIELD18 |
Phone 1 |
20 |
char |
institution_addr.phone_1 |
FIELD19 |
Phone 2 |
20 |
char |
institution_addr.phone_2 |
FIELD20 |
Phone 3 |
20 |
char |
institution_addr.phone_3 |
FIELD21 |
Other Details |
40 |
char |
institution_addr.other_details |
FIELD22 |
NULL |
. |
. |
. |
Field Name |
Field Description |
Max Length |
Type |
Source / Value |
CREATION_DT – CREATION DATE |
The creation date of the extract |
Date |
SYSDATE |
. |
PRIZE_YR |
The Prize Year |
Number |
to_date(cal_instance.start_dt, ‘YYYY’) in context of acad_cal_type and acad_ci_sequence_number parameters |
4 |
DONOR_CD |
The Donor Code for which the Extract was run |
10 |
char |
donor.donor_cd |
PERSON_ID |
The person id of the donor |
10 |
num |
person.person_id |
ORG_UNIT_CD |
The organisational unit code of the donor |
10 |
char |
donor.org_unit_cd |
START_DT |
The start date of the organisation unit |
10 |
Date |
Ou.start_dt |
DONOR_TYPE |
The Donor type of the prize donor |
12 |
char |
Organisation/Person |
CAL_TYPE |
The cal type of the prize year |
10 |
Char |
Person_prize.cal_type |
ACAD_CI_SEQUENCE_ NUMBER KEY8 |
The calendar instance sequence number of the prize year |
10 |
Num |
Person_prize.cal_type |
RECORD_TYPE |
Record Type |
. |
. |
‘DONOR-DTLS ' |
FIELD1 |
The Person ID of the donor |
10 |
num |
person.person_id |
FIELD2 |
The Title of the donor |
10 |
char |
person.title |
FIELD3 |
The surname of the donor |
30 |
Char |
Peson.surname |
FIELD4 |
The Given Names of the donor |
40 |
char |
person.given_names |
FIELD5 |
The description of the donor |
60 |
Char |
Donor. Description |
FIELD6 |
The name of the organisation |
60 |
Char |
Org_Unit. Description |
FIELD7 -26 |
. |
blank |
. |
. |
Field Name |
Field Description |
Max Length |
Type |
Source / Value |
CREATION_DT – |
The creation date of the extract |
date |
SYSDATE |
. |
PRIZE_YR |
The Prize Year |
number |
to_date(cal_instance.start_dt, ‘YYYY’) in context of acad_cal_type and acad_ci_sequence_number parameters |
4 |
DONOR_CD |
The Donor Code for which the Extract was run |
10 |
char |
donor.donor_cd |
PERSON_ID |
The person id of the donor |
10 |
num |
person.person_id |
ORG_UNIT_CD |
The org_unit_cd to which this record refers |
10 |
char |
donor.org_unit_cd |
START_DT |
The start date of the organisation unit |
10 |
Date |
Ou.start_dt |
DONOR_TYPE |
The Donor type of the prize donor |
12 |
char |
Organisation/Person |
CAL_TYPE |
The cal type of the prize year |
10 |
Char |
Person_prize.acad_cal_type |
ACAD_CI_SEQUENCE_ NUMBER |
The calendar instance sequence number of the prize year |
10 |
num |
Person_prize.acad_ci_ sequence_number |
RECORD_TYPE |
Record Type |
. |
. |
‘ADDRESSES’ |
FIELD1 |
Person ID /ORG_UNIT_CD |
10 |
char |
person.person_id /ou.org_unit_cd |
FIELD2 |
Address Type |
10 |
char |
person_addr/org_addr .addr_type |
FIELD3 |
Address Line 1 |
40 |
char |
person_addr/org_addr.addr_line_1 |
FIELD4 |
Address Line 2 |
40 |
char |
person_addr/org_addr .addr_line_2 |
FIELD5 |
Address Line 3 |
40 |
char |
person_addr/org_addr .addr_line_3 |
FIELD6 |
Address Line 4 |
40 |
char |
person_addr/org_addr .addr_line_4 |
FIELD7 |
Address Line 5 |
40 |
char |
person_addr/org_addr .addr_line_5 |
FIELD8 |
Australian Postcode |
4 |
num |
person_addr/org_addr .aust_postcode |
FIELD9 |
Overseas Postal Code |
10 |
char |
person_addr/org_addr .os_code |
FIELD10 |
Phone 1 |
20 |
char |
person_addr/org_addr .phone_1 |
FIELD11 |
Phone 2 |
20 |
char |
person_addr/org_addr .phone_2 |
FIELD12 |
Phone 3 |
20 |
char |
person_addr/org_addr .phone_3 |
FIELD13 |
Other Details |
40 |
char |
person_addr/org_addr .other_details |
FIELD14 |
Correspondence check box |
1 |
char |
Addr_type/org_addr. correspondence_ind |
FIELD15-26 |
. |
. |
. |
Blank |
Field Name |
Field Description |
Max Length |
Type |
Source / Value |
CREATION_DT – CREATION DATE |
The creation date of the extract | Date |
SYSDATE |
. |
PRIZE_YR KEY- 1 |
The Prize Year | Number |
to_date(cal_instance.start _dt, ‘YYYY’) in context of acad_cal_type and acad_ci_sequence_number parameters |
4 |
DONOR_CD KEY2 |
The DONOR CODE for which the Extract was run | 10 |
char |
Prize_donor.donor_cd |
PERSON_ID |
The donor person id to which this record refers | 10 |
Num/char |
Donor.person_id |
ORG_UNIT_CD |
The donor org_unit_cd to which this record refers | 10 |
Num/char |
Donor.org_unit_cd |
START_DT |
The start date of the organisation unit | 10 |
Date |
donor.ou_start_dt |
DONOR TYPE |
The Donor type of the prize donor | 12 |
Char |
Organisation/Person |
CAL_TYPE |
The cal type of the prize year | 10 |
Char |
Person_prize.cal_type |
ACAD_CI_SEQUENCE_ NUMBER |
The calendar instance sequence number of the prize year | 10 |
Num |
Person_prize.cal_type |
PRIZE_CD |
The prize code of the donor | 10 |
Char |
Prize_donor.prize_cd |
PRIZE_TYPE |
The prize type of the recipient | 10 |
Char |
Prize_detail_type.prize_type |
RECORD_TYPE |
Record Type | 20 |
Char |
‘PRIZE-DETAILS’ |
FIELD1 |
The Name of the prize | 60 |
Char |
Prize_detail.prize_name |
FIELD2 |
The Prize Criteria of the prize | 240 |
Char |
Prize_criteria.criteria |
FIELD3 |
The Prize type of the prize | 10 |
Char |
Prize_type.prize_type |
FIELD4 |
The Prize value of the prize | 5 |
Num |
Prize_value.prize_value/person_ prize_value.override_prize_value |
FIELD5 |
The year in which the prize is awarded | 10 |
date |
Prize_detail.prize_name |
FIELD6-26 |
. | . |
. |
Blank |
Field Name |
Field Description |
Max Length |
Type |
Source / Value |
CREATION_DT – CREATION DATE |
The creation date of the extract |
Date |
SYSDATE |
. |
PRIZE_YR |
The Prize Year |
Number |
to_date(cal_instance.start_dt, ‘YYYY’) in context of acad_cal_type and acad_ci_sequence_number parameters |
4 |
DONOR_CD KEY2 |
The DONOR CODE for which the Extract was run |
10 |
char |
Prize_donor.donor_cd |
PERSON_ID |
The donor person id to which this record refers |
10 |
num/char |
Donor.person_id |
ORG_UNIT_CD |
The donor org_unit_cd to which this record refers |
10 |
num/char |
Donor.org_unit_cd |
START_DT |
The start date of the organisation unit |
10 |
Date |
donor.ou_start_dt |
DONOR TYPE |
The Donor type of the prize donor |
12 |
char |
Organisation/Person |
CAL_TYPE |
The cal type of the prize year |
10 |
Char |
Person_prize.cal_type |
ACAD_CI_SEQUENCE_ NUMBER KEY8 |
The calendar instance sequence number of the prize year |
10 |
num |
Person_prize.cal_type |
PRIZE_CD |
The prize code of the donor |
10 |
Char |
Prize_donor.prize_cd |
RCPNT_PERSON_ID |
The person id of the recipient |
10 |
Num |
Prize_prize.person_id |
RECORD_TYPE |
Record Type |
20 |
char |
‘RECIPIENT-DETAILS’ |
FIELD1 |
The date on which the prize is awarded |
10 |
date |
Person_prize.awarded_dt |
FIELD2 |
The Person ID of the person receiving the prize |
10 |
num |
Person_prize.person_id |
FIELD3 |
The Title of the person receiving the prize |
10 |
char |
Person.title |
FIELD4 |
The Surname of the person receiving the prize... |
30 |
char |
Person.surname |
FIELD5 |
The Given Names of the person receiving the prize |
40 |
char |
Person.given_names |
FIELD6 |
Address Type |
10 |
char |
Person_addr .addr_type |
FIELD7 |
Address Line 1 |
40 |
char |
person_addr .addr_line_1 |
FIELD8 |
Address Line 2 |
40 |
char |
Person_addr .addr_line_2 |
FIELD9 |
Address Line 3 |
40 |
char |
person_addr .addr_line_3 |
FIELD10 |
Address Line 4 |
40 |
char |
Person_addr .addr_line_4 |
FIELD11 |
Address Line 5 |
40 |
char |
person_addr .addr_line_5 |
FIELD12 |
Australian Postcode |
4 |
num |
Person_addr. aust_postcode |
FIELD13 |
Overseas Postal Code |
10 |
char |
Person_addr .os_code |
FIELD14 |
Phone 1 |
20 |
char |
Person_addr .phone_1 |
FIELD15 |
Phone 2 |
20 |
char |
Person_addr. phone_2 |
FIELD16 |
Phone 3 |
20 |
char |
Person_addr .phone_3 |
FIELD17 |
Other Details |
40 |
char |
Person_addr .other_details |
FIELD18 |
Correspondence check box |
1 |
char |
Addr_type. correspondence_ind |
FIELD19-26 |
. |
. |
. |
Blank |
Field Name |
Field Description |
Max Length |
Type |
Source / Value |
| CREATION_DT – CREATION DATE | The creation date of the extract | Date | SYSDATE | Date |
| PRIZE_YR | The Prize Year | 4 | to_date(cal_instance.start_dt, ‘YYYY’) in context of acad_cal_type and acad_ci_sequence_number parameters | Number |
| KEY3 - 10 | . | . | . | Blank |
| RECORD TYPE - RECORD_TYPE | Record Type | 20 | 'FOOTER' | Char |
| FIELD1 | Count of record type DONOR DETAILS | 6 | Calculated | Number |
| FIELD2 | Count of record type DONOR ADDRESS DETAILS | 6 | Calculated | Number |
| FIELD3 | Count of record type -PRIZE DETAILS | 6 | Calculated | Number |
| FIELD4 | Count of record type RECIPIENT DETAILS | 6 | Calculated | Number |
| FIELD5 – 26 | NULL | . | . | . |
Last Modified on 19 September, 2007 10:44 AM
History Information
| Release Version | Project | Change to Document |
| 10.1.0.0.0.0 | C21627 | New form |