Download:
pdf |
pdfBOX AVBEG
BOX AVBEG
2:30:07 PM Friday, March 06, 2009
Page Order # :
10
Page 1 of 49
BOX AVBEG
BOX INSTRUCTIONS
( AVQ1005 )
GO TO AV1 - VERIFY ( AVQ1010 ).
ASSIGNMENTS
The AV section is administered if:
SPALIVE ^= 2/AliveAndInstitute and MRES.SPALIVE ^= 3/Deceased, and
MRES.INTTYPE ^= 8/ExitInterviewHadPrev and
MRES.INTTYPE ^= 9/ExitInterviewSkippedPrev.
CREATE ADDRESS AND PHONE RECORDS:
If AV section is administered, create a current round address and phone records for the
SP.
Else do not create new records.
Set on new tblADDRESS record:
tblADDRESS.AddressNum = next sequential #.
tblADDRESS.AddressRnd = current round.
tblADDRESS.AddressType = 'SP'.
tblADDRESS.AddressDetail = 'SP'.
tblADDRESS.AddrRost = ‘01’ (Same as SP's ROST.ROSTNUM).
tblADDRESS.AddrResp = '1'.
tblADDRESS.AddrNum = SP's previous round tblADDRESS.AddressNum + 001.
tblADDRESS.AddrRndc = current round.
tblADDRESS.FirstName = SP's ROST.ROSTFNAM.
tblADDRESS.MiddleInitial = SP's ROST.ROSTMINI.
tblADDRESS.LastName = SP's ROST.ROSTLNAM
tblADDRESS.Relationship = SP's ROST.ROSTREL
tblADDRESS.RelationOS = SP's ROST.ROSTREOS
tblADDRESS.Verify = EMPTY.
Set on new tblPHONE record where tblPHONE.PhoneInstance = 1:
tblPHONE.PhoneNum = next sequential #.
tblPHONE.PhoneRnd = current round.
tblPHONE.PhoneType = 'SP'.
tblPHONE.PhoneDetail = 'SP'.
tblPHONE.PhoneRost = ‘01’ (Same as SP's ROST.ROSTNUM).
tblPHONE.PhoneInstance = '1'.
tblPHONE.PhoneResp = '1'.
tblPHONE.AddrNum = matches SP’s current round tblADDRESS.AddrNum.
tblPHONE.AddrRndc = current round.
tblPHONE.Verify = EMPTY.
Set on new tblPHONE record where tblPHONE.PhoneInstance = 2:
tblPHONE.PhoneNum = next sequential #.
tblPHONE.PhoneRnd = current round.
tblPHONE.PhoneType = 'SP'.
tblPHONE.PhoneDetail = 'SP'.
tblPHONE.PhoneRost = ‘01’ (Same as SP's ROST.ROSTNUM).
tblPHONE.PhoneInstance = '2'.
tblPHONE.PhoneResp = '1'.
tblPHONE.AddrNum = matches SP’s current round tblADDRESS.AddrNum.
tblPHONE.AddrRndc = current round.
tblPHONE.Verify = EMPTY.
COPY INSTRUCTIONS:
If AV section is administered, copy SP's previous round address and phone number(s) to
the SP's current round address and phone records.
2:30:07 PM Friday, March 06, 2009
Page 2 of 49
BOX AVBEG
Else there will not be a current round address or current round phone records for the SP.
Copy fields on tblADDRESS:
tblADDRESS.STAddr1
tblADDRESS.STAddr2
tblADDRESS.City
tblADDRESS.State
tblADDRESS.Zipcode
Copy fields on tblPhone, where PhoneInstance = '1' and '2':
tblPHONE.PhonArea
tblPHONE.Exch
tblPHONE.PhonLocl
tblPHONE.NoPhone
tblPHONE.PhonWher
tblPHONE.PhonWhOS
tblPHONE.SameName
tblPHONE.NameOS
SP'S PREVIOUS ROUND ADDRESS AND PHONE:
SP's previous round address record on tblADDRESS:
tblADDRESS.AddressRnd = previous round.
tblADDRESS.AddressType = 'SP'.
tblADDRESS.AddressDetail = 'SP'.
tblADDRESS.AddrRost = ‘01’ (Same as SP's ROST.ROSTNUM).
SP's previous round primary phone number record on tblPHONE:
tblPHONE.PhoneRnd = previous round.
tblPHONE.PhoneType = 'SP'.
tblPHONE.PhoneDetail = 'SP'.
tblPHONE.PhoneRost = ‘01’ (Same as SP's ROST.ROSTNUM).
tblPHONE.PhoneInstance = '1'.
SP's previous round secondary phone number record on tblPHONE:
tblPHONE.PhoneRnd = previous round.
tblPHONE.PhoneType = 'SP'.
tblPHONE.PhoneDetail = 'SP'.
tblPHONE.PhoneRost = ‘01’ (Same as SP's ROST.ROSTNUM).
tblPHONE.PhoneInstance = '2'.
See detailed instructions below:
ADDRESSNUM
Create new record on tblADDRESS where
tblADDRESS.AddressNum = next sequential #.
ADDRESSRND
tblADDRESS.AddressRnd = current round.
ADDRESSTYPE
tblADDRESS.AddressType = 'SP'.
ADDRROST
tblADDRESS.AddrRost = '01'.
ADDRRESP
tblADDRESS.AddrResp = '1'.
ADDRNUM
tblADDRESS.AddrNum = SP's previous round
tblADDRESS.AddressNum + 001.
ADDRRNDC
tblADDRESS.AddrRndc = current round.
FIRSTNAME
tblADDRESS.FirstName = SP's ROST.ROSTFNAM.
MIDDLEINITIAL
tblADDRESS.MiddleInitial = SP's ROST.ROSTMINI.
LASTNAME
tblADDRESS.LastName = SP's ROST.ROSTLNAM.
RELATIONSHIP
tblADDRESS.Relationship = SP's ROST.ROSTREL.
RELATIONOS
tblADDRESS.RelationOS = SP's ROST.ROSTREOS.
2:30:07 PM Friday, March 06, 2009
Page 3 of 49
BOX AVBEG
STADDR1
tblADDRESS.STAddr1 = SP's previous round
tblADDRESS.STAddr1.
STADDR2
tblADDRESS.STAddr2 = SP's previous round
tblADDRESS.STAddr2.
CITY
tblADDRESS.City = SP's previous round
tblADDRESS.City.
STATE
tblADDRESS.State = SP's previous round
tblADDRESS.State.
ZIPCODE
tblADDRESS.ZipCode = SP's previous round
tblADDRESS.Zipcode.
VERIFY
tblADDRESS.Verify = EMPTY.
PHONENUM
Create 1st new record on tblPHONE where
tblPHONE.PhoneNum = next sequential #.
PHONEINSTANCE
tblPHONE.PhoneInstance = 1.
PHONERND
tblPHONE.PhoneRnd = current round, set on
tblPHONE where tbPHONE.PhoneInstance = 1.
PHONETYPE
tblPHONE.PhoneType = 'SP', set on tblPHONE
where tbPHONE.PhoneInstance = 1.
PHONEROST
tblPHONE.PhoneRost = '01', set on tblPHONE
where tbPHONE.PhoneInstance = 1.
PHONERESP
tblPHONE.PhoneResp = '1', set on tblPHONE where
tbPHONE.PhoneInstance = 1.
ADDRNUM
tblPHONE.AddrNum = tblADDRESS.AddrNum on
SP's current round Address record, set on tblPHONE
where tbPHONE.PhoneInstance = 1.
ADDRRNDC
tblPHONE.AddrRndc = current round, set on
tblPHONE where tbPHONE.PhoneInstance = 1.
PHONAREA
tblPHONE.PhonArea = SP's previous round
tblPHONE.PhonArea. Set on tblPHONE where
tbPHONE.PhoneInstance = 1.
PHONEXCH
tblPHONE.PhonExch = SP's previous round
tblPHONE.PhonExch. Set on tblPHONE where
tbPHONE.PhoneInstance = 1.
PHONLOCL
tblPHONE.PhonLocl = SP's previous round
tblPHONE.PhonLocl. Set on tblPHONE where
tbPHONE.PhoneInstance = 1.
NOPHONE
tblPHONE.NoPhone = SP's previous round
tblPHONE.NoPhone. Set on tblPHONE where
tbPHONE.PhoneInstance = 1.
PHONWHER
tblPHONE.PhonWher = SP's previous round
tblPHONE.PhonWher. Set on tblPHONE where
tbPHONE.PhoneInstance = 1.
PHONWHOS
tblPHONE.PhonWhOS = SP's previous round
tblPHONE.PhonWhOS. Set on tblPHONE where
tbPHONE.PhoneInstance = 1.
SAMENAME
tblPHONE.SameName = SP's previous round
tblPHONE.SameName. Set on tblPHONE where
tbPHONE.PhoneInstance = 1.
NAMEOS
tblPHONE.NameOS = SP's previous round
tblPHONE.NameOS. Set on tblPHONE where
tbPHONE.PhoneInstance = 1.
2:30:07 PM Friday, March 06, 2009
Page 4 of 49
BOX AVBEG
VERIFY
tblPHONE.Verify = empty, set on tblPHONE where
tbPHONE.PhoneInstance = 1.
PHONENUM
Create 2nd new record on tblPHONE where
tblPHONE.PhoneNum = next sequential #.
PHONEINSTANCE
tblPHONE.PhoneInstance = 2.
PHONERND
tblPHONE.PhoneRnd = current round, set on
tblPHONE where tbPHONE.PhoneInstance = 2.
PHONETYPE
tblPHONE.PhoneType = 'SP', set on tblPHONE
where tbPHONE.PhoneInstance = 2.
PHONEROST
tblPHONE.PhoneRost = '01', set on tblPHONE
where tbPHONE.PhoneInstance = 2.
PHONERESP
tblPHONE.PhoneResp = '1', set on tblPHONE where
tbPHONE.PhoneInstance = 2.
ADDRNUM
tblPHONE.AddrNum = tblADDRESS.AddrNum on
SP's current round Address record, set on tblPHONE
where tbPHONE.PhoneInstance = 2.
ADDRRNDC
tblPHONE.AddrRndc = current round, set on
tblPHONE where tbPHONE.PhoneInstance = 2.
PHONAREA
tblPHONE.PhonArea = SP's previous round
tblPHONE.PhonArea. Set on tblPHONE where
tbPHONE.PhoneInstance = 2.
PHONEXCH
tblPHONE.PhonExch = SP's previous round
tblPHONE.PhonExch. Set on tblPHONE where
tbPHONE.PhoneInstance = 2.
PHONLOCL
tblPHONE.PhonLocl = SP's previous round
tblPHONE.PhonLocl. Set on tblPHONE where
tbPHONE.PhoneInstance = 2.
NOPHONE
tblPHONE.NoPhone = SP's previous round
tblPHONE.NoPhone. Set on tblPHONE where
tbPHONE.PhoneInstance = 2.
PHONWHER
tblPHONE.PhonWher = SP's previous round
tblPHONE.PhonWher. Set on tblPHONE where
tbPHONE.PhoneInstance = 2.
PHONWHOS
tblPHONE.PhonWhOS = SP's previous round
tblPHONE.PhonWhOS. Set on tblPHONE where
tbPHONE.PhoneInstance = 2.
SAMENAME
tblPHONE.SameName = SP's previous round
tblPHONE.SameName. Set on tblPHONE where
tbPHONE.PhoneInstance = 2.
NAMEOS
tblPHONE.NameOS = SP's previous round
tblPHONE.NameOS. Set on tblPHONE where
tbPHONE.PhoneInstance = 2.
VERIFY
tblPHONE.Verify = empty, set on tblPHONE where
tbPHONE.PhoneInstance = 2.
ADDRESSDETAIL
tblADDRESS.AddressDetail = 'SP'.
PHONEDETAIL
tblPHONE.PhoneDetail = 'SP', set on tblPHONE
where tbPHONE.PhoneInstance = 1.
PHONEDETAIL
tblPHONE.PhoneDetail = 'SP', set on tblPHONE
where tbPHONE.PhoneInstance = 2.
TECHNICAL NOTES
2:30:07 PM Friday, March 06, 2009
Page 5 of 49
BOX AVBEG
426
AddressPreviousSP
SP's previous round home address =
STAddr1, STAddr2, City, State, Zipcode on tblADDRESS
where (tblADDRESS.AddressType = 'SP' &
tblADDRESS.AddressDetail = 'SP' &
tblADDRESS.AddrRost = '01' &
tblADDRESS.AddressRnd = previous round).
286
AddressCurrentSP
SP's current round home address =
tblADDRESS.STAddr1, STAddr2, City, State, Zipcode on
tblADDRESS where (tblADDRESS.AddressType = 'SP'
& tblADDRESS.AddressDetail = 'SP' &
tblADDRESS.AddrRost = '01' &
tblADDRESS.AddressRnd = current round).
427
Phone1PreviousSP
SP's previous round primary phone number =
tblPHONE.PHONAREA, PHONEXCH, PHONLOCL on
tblPHONE where (tblPHONE.PhoneType = 'SP' &
tblPHONE.PhoneDetail = 'SP' & tblPHONE.PhoneRost =
'01' & tblPHONE.PhoneRnd = previous round &
tblPHONE.PhoneInstance='1').
428
Phone2PreviousSP
SP's previous round secondary phone number =
tblPHONE.PHONAREA, PHONEXCH, PHONLOCL on
tblPHONE where (tblPHONE.PhoneType = 'SP' &
tblPHONE.PhoneDetail = 'SP' & tblPHONE.PhoneRost =
'01' & tblPHONE.PhoneRnd = previous round &
tblPHONE.PhoneInstance='2').
429
Phone1CurrentSP
SP's current round primary phone number =
tblPHONE.PHONAREA, PHONEXCH, PHONLOCL on
tblPHONE where (tblPHONE.PhoneType = 'SP' &
tblPHONE.PhoneDetail = 'SP' & tblPHONE.PhoneRost =
'01' & tblPHONE.PhoneRnd = current round &
tblPHONE.PhoneInstance='1').
430
Phone2CurrentSP
SP's current round secondary phone number
=tblPHONE.PHONAREA, PHONEXCH, PHONLOCL on
tblPHONE where (tblPHONE.PhoneType = 'SP' &
tblPHONE.PhoneDetail = 'SP' & tblPHONE.PhoneRost =
'01' & tblPHONE.PhoneRnd = current round &
tblPHONE.PhoneInstance='2').
DESIGN NOTES
2:30:07 PM Friday, March 06, 2009
Page 6 of 49
AV1
AV1
Page Order # :
Design Screen Type:
Yes/No
Fields:
Field 1:
VERIFY
Enable Functions:
HELP
COMMENTS
JUMPBACK
No
Yes
Yes
Roster Functions:
Add Item
Edit Item
Delete Item
Search Item
No
No
No
No
Grid Functions:
Add Line
Delete Line
No
No
20
Roster Name:
Roster Type:
DISPLAY INSTRUCTIONS:
Context header display:
Question display:
Display SP's current round home address.
Multi Field display:
Roster/Grid Instructions:
Roster/Grid display:
Report display:
TEXT:
Context Header:
Int. Instr I:
Question Text:
Next, I would like to verify [your/(SP's)] home address. I have it
listed as..[READ ADDRESS LISTED BELOW].
Is this correct?
NAME: (SP)
STREET ADDRESS 1: (STREET ADDRESS LINE 1)
STREET ADDRESS 2: (STREET ADDRESS LINE 2)
2:30:10 PM Friday, March 06, 2009
Page 7 of 49
AV1
CITY: (CITY) STATE: (STATE)
ZIPCODE: (ZIPCODE)
Int. Instr II:
INPUT FIELDS / ROUTING
( AVQ1010 )
VERIFY
Field1:
Cheshire Name:
tblADDRESS.VERIFY
First copied to tblCL.OKHMAddr in transformation.
Then transformed to HRND.OKHMADDR in Cheshire.
Item Text display:
Item Text:
Label:
Label Position:
Field Type:
Type Name:
Answers Allowed:
Drop Down List:
Lookup File:
Lookup File Name:
Enumerated
TYesNo
1
No
No
Number Label
1 Yes
2
FieldSize:
Min Value:
Max Value:
Mask:
Route
BOX AV3 - (AVQ1043 )
English text: YES
No
AV2 - STADDR1 ( AVQ1015 )
English text: NO
BACKGROUND VARIABLE ASSIGNMENTS
Collect on tblADDRESS where:
tblADDRESS.AddressRnd = current round,
tblADDRESS.AddressType = 'SP',
tblADDRESS.AddressDetail = 'SP',
tblADDRESS.AddrRost = '01' (same as SP's ROST.ROSTNUM).
SOFT EDIT CHECKS
HARD EDIT CHECKS
TECHNICAL NOTES
286
AddressCurrentSP
2:30:12 PM Friday, March 06, 2009
SP's current round home address =
Page 8 of 49
AV1
tblADDRESS.STAddr1, STAddr2, City, State, Zipcode on
tblADDRESS where (tblADDRESS.AddressType = 'SP'
& tblADDRESS.AddressDetail = 'SP' &
tblADDRESS.AddrRost = '01' &
tblADDRESS.AddressRnd = current round).
DESIGN NOTES
VERIFYING EXISTING ADDRESS FOR SP.
2:30:12 PM Friday, March 06, 2009
Page 9 of 49
AV2
AV2
Page Order # :
Design Screen Type:
Address
Fields:
Field 1:
STADDR1
Field 2:
STADDR2
Field 3:
CITY
Field 4:
STATE
Field 5:
ZIPCODE
HELP
COMMENTS
JUMPBACK
No
Yes
Yes
Roster Functions:
Add Item
Edit Item
Delete Item
Search Item
No
No
No
No
Grid Functions:
Add Line
Delete Line
No
No
Enable Functions:
30
Roster Name:
Roster Type:
DISPLAY INSTRUCTIONS:
Context header display:
Question display:
Multi Field display:
Vertical Alignment
Display all fields at one time. See general specifications for Address
Screen Layout.
Roster/Grid Instructions:
Roster/Grid display:
Report display:
TEXT:
Context Header:
Int. Instr I:
ENTER CORRECT ADDRESS.
Question Text:
Int. Instr II:
2:30:14 PM Friday, March 06, 2009
CLEAR ADDRESS LINE 2 IF NO LONGER APPLICABLE.
Page 10 of 49
AV2
INPUT FIELDS / ROUTING
STADDR1
Field1:
Cheshire Name:
( AVQ1015 )
tblADDRESS.STADDR1
Transformed to ADDR.STADDR1 in Cheshire.
Item Text display:
Display SP's current round home street address line 1,
tblADDRESS.STAddr1, and allow field to be updated.
Item Text:
Label:
Label Position:
STREET ADDRESS 1:
Left
Field Type:
Type Name:
Answers Allowed:
Drop Down List:
Lookup File:
Lookup File Name:
String
TStAddr
1
No
No
Number Label
1 [Continuous answer.]
Attribute
Don't know
Route
AV2 - STADDR2 ( AVQ1020 )
Refusal
AV2 - STADDR2 ( AVQ1020 )
2:30:17 PM Friday, March 06, 2009
FieldSize:
Min Value:
Max Value:
Mask:
45
Route
AV2 - STADDR2 ( AVQ1020 )
Page 11 of 49
AV2
STADDR2
Field2:
Cheshire Name:
( AVQ1020 )
tblADDRESS.STADDR2
Transformed to ADDR.STADDR2 in Cheshire.
Item Text display:
Display SP's current round home street address line 2,
tblADDRESS.STAddr2, and allow field to be updated.
Item Text:
Label:
Label Position:
STREET ADDRESS 2:
Left
Field Type:
Type Name:
Answers Allowed:
Drop Down List:
Lookup File:
Lookup File Name:
String
TSTAddrEmpty
1
No
No
Number Label
1 [Continuous answer.]
Attribute
Empty
Route
AV2 - CITY ( AVQ1025 )
Don't know
AV2 - CITY ( AVQ1025 )
Refusal
AV2 - CITY ( AVQ1025 )
2:30:21 PM Friday, March 06, 2009
FieldSize:
Min Value:
Max Value:
Mask:
45
Route
AV2 - CITY ( AVQ1025 )
Page 12 of 49
AV2
CITY
Field3:
Cheshire Name:
( AVQ1025 )
tblADDRESS.CITY
Transformed to ADDR.CITY in Cheshire.
Item Text display:
Display SP's current round home address city,
tblADDRESS.City, and allow field to be updated.
Item Text:
Label:
Label Position:
CITY:
Left
Field Type:
Type Name:
Answers Allowed:
Drop Down List:
Lookup File:
Lookup File Name:
String
TCity
1
No
No
Number Label
1 [Continuous answer.]
Attribute
Don't know
Route
AV2 - STATE ( AVQ1030 )
Refusal
AV2 - STATE ( AVQ1030 )
2:30:24 PM Friday, March 06, 2009
FieldSize:
Min Value:
Max Value:
Mask:
20
Route
AV2 - STATE ( AVQ1030 )
Page 13 of 49
AV2
STATE
Field4:
Cheshire Name:
( AVQ1030 )
tblADDRESS.STATE
Transformed to ADDR.STATE in Cheshire.
Item Text display:
Display SP's current round home address state,
tblADDRESS.State, and allow field to be updated.
Item Text:
Label:
Label Position:
STATE:
Left
Field Type:
Type Name:
Answers Allowed:
Drop Down List:
Lookup File:
Lookup File Name:
String
TStateSt
1
No
No
Number Label
1 [Continuous answer.]
Attribute
Don't know
Route
AV2 - ZIPCODE ( AVQ1035 )
Refusal
AV2 - ZIPCODE ( AVQ1035 )
2:30:28 PM Friday, March 06, 2009
FieldSize:
Min Value:
Max Value:
Mask:
2
Route
AV2 - ZIPCODE ( AVQ1035 )
Page 14 of 49
AV2
ZIPCODE
Field5:
Cheshire Name:
( AVQ1035 )
tblADDRESS.ZIPCODE
Transformed to ADDR.ZIPCODE in Cheshire.
Item Text display:
Display SP's current round home address zipcode,
tblADDRESS.Zipcode, and allow field to be updated.
Item Text:
Label:
Label Position:
ZIPCODE:
Left
Field Type:
Type Name:
Answers Allowed:
Drop Down List:
Lookup File:
Lookup File Name:
Integer
TZipcodeInt
1
No
No
Number Label
1 [Continuous answer.]
Attribute
Don't know
Route
AV3 - SPMOVED ( AVQ1040 )
Refusal
AV3 - SPMOVED ( AVQ1040 )
FieldSize:
Min Value:
Max Value:
Mask:
5
00000
99999
Route
AV3 - SPMOVED ( AVQ1040 )
BACKGROUND VARIABLE ASSIGNMENTS
Collect on tblADDRESS where:
tblADDRESS.AddressRnd = current round,
tblADDRESS.AddressType = 'SP',
tblADDRESS.AddressDetail = 'SP',
tblADDRESS.AddrRost = '01' (same as SP's ROST.ROSTNUM).
If Street Address Line 2 is cleared, update SP's current round tblADDRESS.STADDR2 =
empty.
See detailed instructions below.
STAddr2
If AV2 - STADDR2 is cleared, set
tblADDRESS.STADDR2 = empty.
SOFT EDIT CHECKS
HARD EDIT CHECKS
TECHNICAL NOTES
2:30:30 PM Friday, March 06, 2009
Page 15 of 49
AV2
286
AddressCurrentSP
SP's current round home address =
tblADDRESS.STAddr1, STAddr2, City, State, Zipcode on
tblADDRESS where (tblADDRESS.AddressType = 'SP'
& tblADDRESS.AddressDetail = 'SP' &
tblADDRESS.AddrRost = '01' &
tblADDRESS.AddressRnd = current round).
DESIGN NOTES
UPDATING SP'S HOME ADDRESS.
2:30:30 PM Friday, March 06, 2009
Page 16 of 49
AV3
AV3
Page Order # :
Design Screen Type:
Yes/No
Fields:
Field 1:
SPMOVED
Enable Functions:
HELP
COMMENTS
JUMPBACK
No
Yes
Yes
Roster Functions:
Add Item
Edit Item
Delete Item
Search Item
No
No
No
No
Grid Functions:
Add Line
Delete Line
No
No
40
Roster Name:
Roster Type:
DISPLAY INSTRUCTIONS:
Context header display:
Question display:
Multi Field display:
Roster/Grid Instructions:
Roster/Grid display:
Report display:
TEXT:
Context Header:
Int. Instr I:
WAS CHANGE MADE TO SP'S ADDRESS BECAUSE SP MOVED?
Question Text:
Int. Instr II:
INPUT FIELDS / ROUTING
2:30:31 PM Friday, March 06, 2009
Page 17 of 49
AV3
SPMOVED
Field1:
Cheshire Name:
( AVQ1040 )
tblCL.SPMOVED.
Transformed to HRND.SPMOVED in Cheshire.
Item Text display:
Item Text:
Label:
Label Position:
Field Type:
Type Name:
Answers Allowed:
Drop Down List:
Lookup File:
Lookup File Name:
Enumerated
TYesNoDKRF
1
No
No
Number Label
1 Yes
2
FieldSize:
Min Value:
Max Value:
Mask:
Route
BOX AV3 - (AVQ1043 )
English text: YES
No
English text: NO
Attribute
Don't know
Route
BOX AV3 - (AVQ1043 )
Refusal
BOX AV3 - (AVQ1043 )
BOX AV3 - (AVQ1043 )
BACKGROUND VARIABLE ASSIGNMENTS
SOFT EDIT CHECKS
HARD EDIT CHECKS
TECHNICAL NOTES
DESIGN NOTES
2:30:33 PM Friday, March 06, 2009
Page 18 of 49
BOX AV3
BOX AV3
45
Page Order # :
BOX INSTRUCTIONS
( AVQ1043 )
IF A PRIMARY PHONE NUMBER HAS BEEN COLLECTED FOR THE SP,
GO TO AV4 - VERIFY ( AVQ1045 ).
ELSE GO TO AV5 - PHONAREA ( AVQ1050 ).
ASSIGNMENTS
TECHNICAL NOTES
291
PhonePrimCollectedSP
A Primary Phone number was collected for SP =
tblPHONE.NoPhone ^= 1/NotHavePhone on tblPHONE
where tblPHONE.PhoneRnd = current round &
tblPHONE.PhoneType = 'SP' & tblPHONE.PhoneDetail =
'SP' & tblPHONE.PhoneRost = '01' &
tblPHONE.PhoneInstance = '1';
DESIGN NOTES
2:30:33 PM Friday, March 06, 2009
Page 19 of 49
AV4
AV4
Page Order # :
Design Screen Type:
Yes/No
Fields:
Field 1:
VERIFY
Enable Functions:
HELP
COMMENTS
JUMPBACK
No
Yes
Yes
Roster Functions:
Add Item
Edit Item
Delete Item
Search Item
No
No
No
No
Grid Functions:
Add Line
Delete Line
No
No
50
Roster Name:
Roster Type:
DISPLAY INSTRUCTIONS:
Context header display:
Question display:
Always display "(s)" and "(S)" in parenthesis.
PHONE 1:
Display SP's current Primary Phone Number.
PHONE 2:
If a secondary phone number was collected for the SP, then display
SP's current Primary Phone Number.
Else display "NONE".
Multi Field display:
Roster/Grid Instructions:
Roster/Grid display:
Report display:
TEXT:
Context Header:
Int. Instr I:
Question Text:
2:30:34 PM Friday, March 06, 2009
Next, I would like to verify [your/(SP's)] phone number(s). I have
them listed as ..[READ PHONE NUMBER(S) LISTED BELOW].
Page 20 of 49
AV4
Are these correct?
PHONE 1: (PRIMARY PHONE NUMBER)
PHONE 2: [(SECONDARY PHONE NUMBER)/NONE)
Int. Instr II:
INPUT FIELDS / ROUTING
VERIFY
Field1:
Cheshire Name:
( AVQ1045 )
tblPHONE.VERIFY.
First copied to tblCL.OKHMPhon in transformation.
Then transformed to HRND.OKHMPHON in Cheshire.
Item Text display:
Item Text:
Label:
Label Position:
Field Type:
Type Name:
Answers Allowed:
Drop Down List:
Lookup File:
Lookup File Name:
Enumerated
TYesNo
1
No
No
Number Label
1 Yes
2
English text: YES
No
FieldSize:
Min Value:
Max Value:
Mask:
Route
BOX AV6 - (AVQ1082 )
AV5 - PHONAREA ( AVQ1050 )
English text: NO
BACKGROUND VARIABLE ASSIGNMENTS
Collect on tblPHONE where:
tblPHONE.PhoneRnd = current round,
tblPHONE.PhoneType = 'SP',
tblPHONE.PhoneDetail = 'SP',
tblPHONE.AddrRost = '01' (same as SP's ROST.ROSTNUM),
tblPHONE.PhoneInstance = '1'.
If AV4 - VERIFY = 2/No, update SP's current round phone number(s) to empty. We will
probe for new phone numbers.
See detailed instructions below.
2:30:36 PM Friday, March 06, 2009
Page 21 of 49
AV4
PHONAREA
If AV4 - VERIFY = 2/No, update SP's current round
tblPHONE.PhonArea = empty on tblPHONE where
tblPHONE.PhoneInstance = '2';
PHONEXCH
If AV4 - VERIFY = 2/No, update SP's current round
tblPHONE.PhonExch = empty on tblPHONE where
tblPHONE.PhoneInstance = '2';
PHONLOCL
If AV4 - VERIFY = 2/No, update SP's current round
tblPHONE.PhonLocl = empty on tblPHONE where
tblPHONE.PhoneInstance = '2';
NOPHONE
If AV4 - VERIFY = 2/No, update SP's current round
tblPHONE.NoPhone = empty on tblPHONE where
tblPHONE.PhoneInstance = '2';
PHONAREA
If AV4 - VERIFY = 2/No, update SP's current round
tblPHONE.PhonArea = empty on tblPHONE where
tblPHONE.PhoneInstance = '1';
PHONEXCH
If AV4 - VERIFY = 2/No, update SP's current round
tblPHONE.PhonExch = empty on tblPHONE where
tblPHONE.PhoneInstance = '1';
PHONLOCL
If AV4 - VERIFY = 2/No, update SP's current round
tblPHONE.PhonLocl = empty on tblPHONE where
tblPHONE.PhoneInstance = '1';
NOPHONE
If AV4 - VERIFY = 2/No, update SP's current round
tblPHONE.NoPhone = empty on tblPHONE where
tblPHONE.PhoneInstance = '1';
SOFT EDIT CHECKS
HARD EDIT CHECKS
TECHNICAL NOTES
429
Phone1CurrentSP
SP's current round primary phone number =
tblPHONE.PHONAREA, PHONEXCH, PHONLOCL on
tblPHONE where (tblPHONE.PhoneType = 'SP' &
tblPHONE.PhoneDetail = 'SP' & tblPHONE.PhoneRost =
'01' & tblPHONE.PhoneRnd = current round &
tblPHONE.PhoneInstance='1').
309
PhoneSecCollectedSP
A Secondary Phone number was collected for SP =
tblPHONE.NoPhone ^= 1/NotHavePhone on tblPHONE
where tblPHONE.PhoneRnd = current round &
tblPHONE.PhoneType = 'SP' & tblPHONE.PhoneDetail =
'SP' & tblPHONE.PhoneRost = '01' &
tblPHONE.PhoneInstance = '2';
430
Phone2CurrentSP
SP's current round secondary phone number
=tblPHONE.PHONAREA, PHONEXCH, PHONLOCL on
tblPHONE where (tblPHONE.PhoneType = 'SP' &
tblPHONE.PhoneDetail = 'SP' & tblPHONE.PhoneRost =
'01' & tblPHONE.PhoneRnd = current round &
tblPHONE.PhoneInstance='2').
DESIGN NOTES
VERIFYING SP'S PHONE NUMBERS.
2:30:36 PM Friday, March 06, 2009
Page 22 of 49
AV5
AV5
Page Order # :
Design Screen Type:
Phone
Fields:
Field 1:
PHONAREA
Field 2:
PHONEXCH
Field 3:
PHONLOCL
Field 4:
NOPHONE
HELP
COMMENTS
JUMPBACK
No
Yes
Yes
Roster Functions:
Add Item
Edit Item
Delete Item
Search Item
No
No
No
No
Grid Functions:
Add Line
Delete Line
No
No
Enable Functions:
60
Roster Name:
Roster Type:
DISPLAY INSTRUCTIONS:
Context header display:
Question display:
Multi Field display:
Horizontal Alignment
Display all fields at one time. See General Specifications for Phone
Screen layout.
Roster/Grid Instructions:
Roster/Grid display:
Report display:
TEXT:
Context Header:
Int. Instr I:
Question Text:
What is [your/(SP's)] phone number?
Int. Instr II:
INPUT FIELDS / ROUTING
2:30:38 PM Friday, March 06, 2009
Page 23 of 49
AV5
PHONAREA
Field1:
Cheshire Name:
( AVQ1050 )
tblPHONE.PHONAREA
Transformed to ADDR.PHONAREA in Cheshire.
tblPHONE.PHONAREA = RF on Phone Instance = 1 is
transformed to the following in Cheshire:
ADDR.PHONAREA = 999
ADDR.PHONEXCH = NULL
ADDR.PHONLOCL = NULL
ADDR.PHONAR2 = 999
ADDR.PHONEX2 = NULL
ADDR.PHONLO2 = NULL
Item Text display:
Do not display previously collected phone number. AV5
will update existing phone number.
Item Text:
Label:
Label Position:
PHONE NUMBER 1:
Left
Field Type:
Type Name:
Answers Allowed:
Drop Down List:
Lookup File:
Lookup File Name:
Integer
TareaDKRF
1
No
No
Number Label
1 [Continuous answer.]
Attribute
Empty
Route
AV5 - PHONEXCH ( AVQ1055 )
Don't know
AV5 - PHONEXCH ( AVQ1055 )
Refusal
AV5 - PHONEXCH ( AVQ1055 )
2:30:42 PM Friday, March 06, 2009
FieldSize:
Min Value:
Max Value:
Mask:
3
100
999
Route
AV5 - PHONEXCH ( AVQ1055 )
Page 24 of 49
AV5
PHONEXCH
Field2:
Cheshire Name:
( AVQ1055 )
tblPHONE.PHONEXCH
Transformed to ADDR.PHONEXCH in Cheshire.
Item Text display:
Do not display previously collected phone number. AV5
will update existing phone number.
Item Text:
Label:
Label Position:
Field Type:
Type Name:
Answers Allowed:
Drop Down List:
Lookup File:
Lookup File Name:
Integer
TexchangeDKRF
1
No
No
Number Label
1 [Continuous answer.]
Attribute
Empty
Route
AV5 - PHONLOCL ( AVQ1060 )
Don't know
AV5 - PHONLOCL ( AVQ1060 )
Refusal
AV5 - PHONLOCL ( AVQ1060 )
2:30:45 PM Friday, March 06, 2009
FieldSize:
Min Value:
Max Value:
Mask:
200
999
Route
AV5 - PHONLOCL ( AVQ1060 )
Page 25 of 49
AV5
PHONLOCL
Field3:
Cheshire Name:
( AVQ1060 )
tblPHONE.PHONLOCL
Transformed to ADDR.PHONLOCL in Cheshire.
Item Text display:
Do not display previously collected phone number. AV5
will update existing phone number.
Item Text:
Label:
Label Position:
Field Type:
Type Name:
Answers Allowed:
Drop Down List:
Lookup File:
Lookup File Name:
Integer
TlocalDKRF
1
No
No
Number Label
1 [Continuous answer.]
Attribute
Empty
Route
AV5 - NOPHONE ( AVQ1061 )
Don't know
AV5 - NOPHONE ( AVQ1061 )
Refusal
AV5 - NOPHONE ( AVQ1061 )
2:30:49 PM Friday, March 06, 2009
FieldSize:
Min Value:
Max Value:
Mask:
0000
9999
Route
AV5 - NOPHONE ( AVQ1061 )
Page 26 of 49
AV5
NOPHONE
Field4:
Cheshire Name:
( AVQ1061 )
NONE
SQL = tblPHONE.NOPHONE
tblPHONE.NOPHONE = 1/NotHavePhone on Phone Instance
= 1 is transformed to the following in Cheshire:
ADDR.PHONAREA = 999
ADDR.PHONEXCH = NULL
ADDR.PHONLOCL = NULL
ADDR.PHONAR2 = 999
ADDR.PHONEX2 = NULL
ADDR.PHONLO2 = NULL
Item Text display:
Do not display previously collected response to
tblPHONE.NoPhone. AV5 will update existing phone
number.
Item Text:
Label:
Label Position:
Field Type:
Type Name:
Answers Allowed:
Drop Down List:
Lookup File:
Lookup File Name:
Enumerated
TNoPhone
1
No
No
FieldSize:
Min Value:
Max Value:
Mask:
Number Label
1 NotHavePhone
Route
BOX AV5 - (AVQ1065 )
English text: PERSON DOES NOT HAVE PHONE
Attribute
Empty
Route
BOX AV5 - (AVQ1065 )
BACKGROUND VARIABLE ASSIGNMENTS
Collect on tblPHONE where:
tblPHONE.PhoneRnd = current round,
tblPHONE.PhoneType = 'SP',
tblPHONE.PhoneDetail = 'SP',
tblPHONE.AddrRost = '01' (same as SP's ROST.ROSTNUM),
tblPHONE.PhoneInstance = '1'.
SOFT EDIT CHECKS
HARD EDIT CHECKS
2:30:51 PM Friday, March 06, 2009
Page 27 of 49
AV5
Edit #1
If NOPHONE = 1/NoPhone, then PHONAREA, PHONEXCH, and
PHONLOCL should be empty.
If not true, display "PLEASE ENTER PHONE NUMBER OR SELECT
"PERSON DOES NOT HAVE PHONE".".
Edit #2
If NOPHONE= EMPTY, then PHONAREA, PHONEXCH, and
PHONLOCL should not be empty.
If not true, display "PLEASE ENTER PHONE NUMBER OR SELECT
"PERSON DOES NOT HAVE PHONE".".
TECHNICAL NOTES
DESIGN NOTES
UPDATING SP'S PHONE 1.
2:30:51 PM Friday, March 06, 2009
Page 28 of 49
BOX AV5
BOX AV5
Page Order # :
70
BOX INSTRUCTIONS
( AVQ1065 )
IF AV5 - NOPHONE = 1/NotHavePhone OR AV5 - PHONAREA = RF, GO TO
BOX AV6 - (AVQ1082 ).
ELSE GO TO AV6 - PHONAREA ( AVQ1070 ).
ASSIGNMENTS
TECHNICAL NOTES
DESIGN NOTES
2:30:51 PM Friday, March 06, 2009
Page 29 of 49
AV6
AV6
Page Order # :
Design Screen Type:
Phone
Fields:
Field 1:
PHONAREA
Field 2:
PHONEXCH
Field 3:
PHONLOCL
Field 4:
NOPHONE
HELP
COMMENTS
JUMPBACK
No
Yes
Yes
Roster Functions:
Add Item
Edit Item
Delete Item
Search Item
No
No
No
No
Grid Functions:
Add Line
Delete Line
No
No
Enable Functions:
80
Roster Name:
Roster Type:
DISPLAY INSTRUCTIONS:
Context header display:
Question display:
Multi Field display:
Horizontal Alignment
Display all fields at one time. See General Specifications for Phone
Screen layout.
Roster/Grid Instructions:
Roster/Grid display:
Report display:
TEXT:
Context Header:
Int. Instr I:
Question Text:
Do you/Does (SP)] have a second phone number?
[PROBE: What is that number?]
Int. Instr II:
2:30:53 PM Friday, March 06, 2009
Page 30 of 49
AV6
INPUT FIELDS / ROUTING
PHONAREA
Field1:
Cheshire Name:
( AVQ1070 )
tblPHONE.PHONAREA
Transformed to ADDR.PHONAR2 in Cheshire.
tblPHONE.PHONAREA = RF on Phone Instance = 2 is
transformed to the following in Cheshire:
ADDR.PHONAR2 = 999
ADDR.PHONEX2 = NULL
ADDR.PHONLO2 = NULL
Item Text display:
Do not display previously collected phone number. AV6
will update existing phone number.
Item Text:
Label:
Label Position:
PHONE NUMBER 2:
Left
Field Type:
Type Name:
Answers Allowed:
Drop Down List:
Lookup File:
Lookup File Name:
Integer
TareaDKRF
1
No
No
Number Label
1 [Continuous answer.]
Attribute
Empty
Route
AV6 - PHONEXCH ( AVQ1075 )
Don't know
AV6 - PHONEXCH ( AVQ1075 )
Refusal
AV6 - PHONEXCH ( AVQ1075 )
2:30:57 PM Friday, March 06, 2009
FieldSize:
Min Value:
Max Value:
Mask:
3
100
999
Route
AV6 - PHONEXCH ( AVQ1075 )
Page 31 of 49
AV6
PHONEXCH
Field2:
Cheshire Name:
( AVQ1075 )
tblPHONE.PHONEXCH
Transformed to ADDR.PHONEX2 in Cheshire.
Item Text display:
Do not display previously collected phone number. AV6
will update existing phone number.
Item Text:
Label:
Label Position:
Field Type:
Type Name:
Answers Allowed:
Drop Down List:
Lookup File:
Lookup File Name:
Integer
TexchangeDKRF
1
No
No
Number Label
1 [Continuous answer.]
Attribute
Empty
Route
AV6 - PHONLOCL ( AVQ1080 )
Don't know
AV6 - PHONLOCL ( AVQ1080 )
Refusal
AV6 - PHONLOCL ( AVQ1080 )
2:31:00 PM Friday, March 06, 2009
FieldSize:
Min Value:
Max Value:
Mask:
200
999
Route
AV6 - PHONLOCL ( AVQ1080 )
Page 32 of 49
AV6
PHONLOCL
Field3:
Cheshire Name:
( AVQ1080 )
tblPHONE.PHONLOCL
Transformed to ADDR.PHONLO2 in Cheshire.
Item Text display:
Do not display previously collected phone number. AV6
will update existing phone number.
Item Text:
Label:
Label Position:
Field Type:
Type Name:
Answers Allowed:
Drop Down List:
Lookup File:
Lookup File Name:
Integer
TlocalDKRF
1
No
No
Number Label
1 [Continuous answer.]
Attribute
Empty
Route
AV6 - NOPHONE ( AVQ1081 )
Don't know
AV6 - NOPHONE ( AVQ1081 )
Refusal
AV6 - NOPHONE ( AVQ1081 )
2:31:04 PM Friday, March 06, 2009
FieldSize:
Min Value:
Max Value:
Mask:
0000
9999
Route
AV6 - NOPHONE ( AVQ1081 )
Page 33 of 49
AV6
NOPHONE
Field4:
Cheshire Name:
( AVQ1081 )
NONE
SQL = tblPHONE.NOPHONE
tblPHONE.NOPHONE = 1/NotHavePhone on Phone Instance
= 2 is transformed to the following in Cheshire:
ADDR.PHONAR2 = 999
ADDR.PHONEX2 = NULL
ADDR.PHONLO2 = NULL
ADDR.PHONEX2 = NULL
ADDR.PHONLO2 = NULL
Item Text display:
Do not display previously collected response to
tblPHONE.NoPhone. AV6 will update existing phone
number.
Item Text:
Label:
Label Position:
Field Type:
Type Name:
Answers Allowed:
Drop Down List:
Lookup File:
Lookup File Name:
Enumerated
TNoPhone
1
No
No
Number Label
1 NotHavePhone
FieldSize:
Min Value:
Max Value:
Mask:
Route
BOX AV6 - (AVQ1082 )
English text: PERSON DOES NOT HAVE PHONE
Attribute
Empty
Route
BOX AV6 - (AVQ1082 )
BACKGROUND VARIABLE ASSIGNMENTS
Collect on tblPHONE where:
tblPHONE.PhoneRnd = current round,
tblPHONE.PhoneType = 'SP',
tblPHONE.PhoneDetail = 'SP',
tblPHONE.AddrRost = '01' (same as SP's ROST.ROSTNUM),
tblPHONE.PhoneInstance = '2'.
SOFT EDIT CHECKS
HARD EDIT CHECKS
2:31:07 PM Friday, March 06, 2009
Page 34 of 49
AV6
Edit #1
If NOPHONE = 1/NoPhone, then PHONAREA, PHONEXCH, and
PHONLOCL should be empty.
If not true, display "PLEASE ENTER PHONE NUMBER OR SELECT
"PERSON DOES NOT HAVE PHONE".".
Edit #2
If NOPHONE= EMPTY, then PHONAREA, PHONEXCH, and
PHONLOCL should not be empty.
If not true, display "PLEASE ENTER PHONE NUMBER OR SELECT
"PERSON DOES NOT HAVE PHONE".".
TECHNICAL NOTES
430
Phone2CurrentSP
SP's current round secondary phone number
=tblPHONE.PHONAREA, PHONEXCH, PHONLOCL on
tblPHONE where (tblPHONE.PhoneType = 'SP' &
tblPHONE.PhoneDetail = 'SP' & tblPHONE.PhoneRost =
'01' & tblPHONE.PhoneRnd = current round &
tblPHONE.PhoneInstance='2').
DESIGN NOTES
UPDATING SP'S PHONE 2.
2:31:07 PM Friday, March 06, 2009
Page 35 of 49
BOX AV6
BOX AV6
2:31:07 PM Friday, March 06, 2009
Page Order # :
85
Page 36 of 49
BOX AV6
BOX INSTRUCTIONS
( AVQ1082 )
CHECK FOR SP'S PREVIOUS ROUND MAILING ADDRESS. IF SP'S
MAILING ADDRESS WAS NOT COLLECTED IN THE PREVIOUS ROUND,
COPY SP'S CURRENT ROUND ADDRESS TO SP'S MAILING ADDRESS .
GO TO AV7 - VERIFY ( AVQ1085 ).
ASSIGNMENTS
CREATE NEW ADDRESS RECORD:
Create a current round address record for SP's mailing address.
Set on new tblADDRESS record:
tblADDRESS.AddressNum = next sequential #.
tblADDRESS.AddressRnd = current round.
tblADDRESS.AddressType = 'MAIL'.
tblADDRESS.AddressDetail = 'MAIL'.
tblADDRESS.AddrRost = '0'.
tblADDRESS.AddrResp = '1'.
tblADDRESS.AddrNum = EMPTY.
tblADDRESS.FirstName = EMPTY.
tblADDRESS.MiddleInitial = EMPTY.
tblADDRESS.LastName = EMPTY.
tblADDRESS.Relationship = EMPTY.
tblADDRESS.RelationOS = EMPTY.
tblADDRESS.Verify = EMPTY.
COPY INSTRUCTIONS:
If SP does not have a previous round mailing address, copy SP's current round home
address to the SP's current round mailing address record.
Else copy SP's previous round mailing address to SP's current round mailing address
record.
Copy fields on tblADDRESS:
tblADDRESS.STAddr1
tblADDRESS.STAddr2
tblADDRESS.City
tblADDRESS.State
tblADDRESS.Zipcode
SP'S PREVIOUS ROUND MAILING ADDRESS:
tblADDRESS.AddressRnd = previous round.
tblADDRESS.AddressType = 'MAIL'.
tblADDRESS.AddressDetail = 'MAIL'.
SP'S CURRENT ROUND ADDRESS AND PHONE:
SP's current round address record on tblADDRESS:
blADDRESS.AddressRnd = current round.
tblADDRESS.AddressType = 'SP'.
tblADDRESS.AddressDetail = 'SP'.
tblADDRESS.AddrRost = '01';.
See detailed instructions below:
ADDRESSNUM
Create record where tblADDRESS.AddressNum =
next sequential #.
ADDRESSRND
tblADDRESS.AddressRnd = current round.
2:31:07 PM Friday, March 06, 2009
Page 37 of 49
BOX AV6
ADDRESSTYPE
tblADDRESS.AddressType = 'MAIL'.
ADDRROST
tblADDRESS.AddrRost = '0';
ADDRRESP
tblADDRESS.AddrResp = '1'.
ADDRNUM
tblADDRESS.AddrNum = EMPTY.
ADDRRNDC
tblADDRESS.AddrRndc = EMPTY.
FIRSTNAME
tblADDRESS.FirstName = EMPTY.
MIDDLEINITIAL
tblADDRESS.MiddleInitial = EMPTY.
LASTNAME
tblADDRESS.LastName = EMPTY.
RELATIONSHIP
tblADDRESS.Relationship = EMPTY.
RELATIONOS
tblADDRESS.RelationOS = EMPTY.
VERIFY
tblADDRESS.Verify = EMPTY.
STADDR2
tblADDRESS.STADDR2 = set as instructed above.
CITY
tblADDRESS.CITY = set as instructed above.
STATE
tblADDRESS.STATE = set as instructed above.
ZIPCODE
tblADDRESS.ZIPCODE = set as instructed above.
ADDRESSDETAIL
tblADDRESS.AddressDetail = 'MAIL'.
STADDR1
tblADDRESS.STADDR1 = set as instructed above.
TECHNICAL NOTES
280
AddressPrevMailCollect
ed
Mailing Address was collected for SP in the previous
round =
tblADDRESS.STAddr1 ^= empty on tblADDRESS where
(tblADDRESS.AddressType = 'MAIL' and
tblADDRESS.AddressDetail = 'MAIL' and
tblADDRESS.AddressRnd = previous round).
318
AddressPrevMailing
SP's previous round mailing address =
tblADDRESS.STAddr1, STAddr2, City, State, Zipcode on
tblADDRESS where (tblADDRESS.AddressType = 'MAIL'
and tblADDRESS.AddressDetail = 'MAIL' &
tblADDRESS.AddressRnd = previous round).
286
AddressCurrentSP
SP's current round home address =
tblADDRESS.STAddr1, STAddr2, City, State, Zipcode on
tblADDRESS where (tblADDRESS.AddressType = 'SP'
& tblADDRESS.AddressDetail = 'SP' &
tblADDRESS.AddrRost = '01' &
tblADDRESS.AddressRnd = current round).
281
AddressCurrentMail
SP's current round mailing address =
tblADDRESS.STAddr1, STAddr2, City, State, Zipcode on
tblADDRESS where (tblADDRESS.AddressType = 'MAIL'
& tblADDRESS.AddressDetail = 'MAIL' &
tblADDRESS.AddressRnd = current round).
DESIGN NOTES
2:31:07 PM Friday, March 06, 2009
Page 38 of 49
AV7
AV7
Page Order # :
Design Screen Type:
Yes/No
Fields:
Field 1:
VERIFY
Enable Functions:
HELP
COMMENTS
JUMPBACK
No
Yes
Yes
Roster Functions:
Add Item
Edit Item
Delete Item
Search Item
No
No
No
No
Grid Functions:
Add Line
Delete Line
No
No
90
Roster Name:
Roster Type:
DISPLAY INSTRUCTIONS:
Context header display:
Question display:
Display SP's current round mailing address.
Display "mailing" in BOLD.
Multi Field display:
Roster/Grid Instructions:
Roster/Grid display:
Report display:
TEXT:
Context Header:
Int. Instr I:
Question Text:
I would also like to verify [your/(SP's)] mailing address. I have it
listed as ... [READ ADDRESS LISTED BELOW.]
Is this the correct mailing address for [you/(SP)]?
NAME: (SP)
MAILING ADDRESS 1: (MAILING ADDRESS LINE 1)
2:31:08 PM Friday, March 06, 2009
Page 39 of 49
AV7
MAILING ADDRESS 2: (MAILING ADDRESS LINE 2)
CITY: (MAILING CITY) STATE: (MAILING STATE) ZIPCODE:
(MAILING ZIPCODE)
Int. Instr II:
INPUT FIELDS / ROUTING
VERIFY
Field1:
Cheshire Name:
( AVQ1085 )
tblADDRESS.VERIFY.
First copied to tblCL.OKMAddr in transformation.
Then transformed to HRND.OKMADDR in Cheshire.
Item Text display:
Item Text:
Label:
Label Position:
Field Type:
Type Name:
Answers Allowed:
Drop Down List:
Lookup File:
Lookup File Name:
Enumerated
TYesNoDKRF
1
No
No
Number Label
1 Yes
2
FieldSize:
Min Value:
Max Value:
Mask:
Route
BOX AVEND - (AVQ1115 )
English text: YES
No
AV8 - STADDR1 ( AVQ1090 )
English text: NO
Attribute
Don't know
Route
BOX AVEND - (AVQ1115 )
Refusal
BOX AVEND - (AVQ1115 )
BACKGROUND VARIABLE ASSIGNMENTS
Collect on tblADDRESS where:
tblADDRESS.AddressRnd = current round,
tblADDRESS.AddressType = 'MAIL',,
tblADDRESS.AddressDetail = 'MAIL'.
SOFT EDIT CHECKS
2:31:11 PM Friday, March 06, 2009
Page 40 of 49
AV7
HARD EDIT CHECKS
TECHNICAL NOTES
281
AddressCurrentMail
SP's current round mailing address =
tblADDRESS.STAddr1, STAddr2, City, State, Zipcode on
tblADDRESS where (tblADDRESS.AddressType = 'MAIL'
& tblADDRESS.AddressDetail = 'MAIL' &
tblADDRESS.AddressRnd = current round).
DESIGN NOTES
VERIFYING SP'S MAILING ADDRESS.
2:31:11 PM Friday, March 06, 2009
Page 41 of 49
AV8
AV8
Page Order # :
Design Screen Type:
Address
Fields:
Field 1:
STADDR1
Field 2:
STADDR2
Field 3:
CITY
Field 4:
STATE
Field 5:
ZIPCODE
HELP
COMMENTS
JUMPBACK
No
Yes
Yes
Roster Functions:
Add Item
Edit Item
Delete Item
Search Item
No
No
No
No
Grid Functions:
Add Line
Delete Line
No
No
Enable Functions:
100
Roster Name:
Roster Type:
DISPLAY INSTRUCTIONS:
Context header display:
Question display:
Multi Field display:
Vertical Alignment
Display all fields at one time. See general specifications for Address
Screen Layout.
Roster/Grid Instructions:
Roster/Grid display:
Report display:
TEXT:
Context Header:
Int. Instr I:
ENTER CORRECT ADDRESS.
Question Text:
What is [your/(SP's)] mailing address?
Int. Instr II:
CLEAR ADDRESS LINE 2 IF NO LONGER APPLICABLE.
2:31:13 PM Friday, March 06, 2009
Page 42 of 49
AV8
INPUT FIELDS / ROUTING
STADDR1
Field1:
Cheshire Name:
( AVQ1090 )
tblADDRESS.STADDR1
Transformed to HOME.MSTADDR1 in Cheshire.
Item Text display:
Display SP's current mailing street address line 1,
tblADDRESS.STAddr1, and allow field to be updated.
Item Text:
Label:
Label Position:
STREET ADDRESS 1:
Left
Field Type:
Type Name:
Answers Allowed:
Drop Down List:
Lookup File:
Lookup File Name:
String
TStAddr
1
No
No
Number Label
1 [Continuous answer.]
Attribute
Don't know
Route
AV8 - STADDR2 ( AVQ1095 )
Refusal
AV8 - STADDR2 ( AVQ1095 )
2:31:16 PM Friday, March 06, 2009
FieldSize:
Min Value:
Max Value:
Mask:
45
Route
AV8 - STADDR2 ( AVQ1095 )
Page 43 of 49
AV8
STADDR2
Field2:
Cheshire Name:
( AVQ1095 )
tblADDRESS.STADDR2
Transformed to HOME.MSTADDR2 in Cheshire.
Item Text display:
Display SP's current mailing street address line 2,
tblADDRESS.STAddr2, and allow field to be updated.
Item Text:
Label:
Label Position:
STREET ADDRESS 2:
Left
Field Type:
Type Name:
Answers Allowed:
Drop Down List:
Lookup File:
Lookup File Name:
String
TSTAddrEmpty
1
No
No
Number Label
1 [Continuous answer.]
Attribute
Empty
Route
AV8 - CITY ( AVQ1100 )
Don't know
AV8 - CITY ( AVQ1100 )
Refusal
AV8 - CITY ( AVQ1100 )
2:31:20 PM Friday, March 06, 2009
FieldSize:
Min Value:
Max Value:
Mask:
45
Route
AV8 - CITY ( AVQ1100 )
Page 44 of 49
AV8
CITY
Field3:
Cheshire Name:
( AVQ1100 )
tblADDRESS.CITY
Transformed to HOME.MCITY in Cheshire.
Item Text display:
Display SP's current mailing address city,
tblADDRESS.City, and allow field to be updated.
Item Text:
Label:
Label Position:
CITY:
Left
Field Type:
Type Name:
Answers Allowed:
Drop Down List:
Lookup File:
Lookup File Name:
String
TCity
1
No
No
Number Label
1 [Continuous answer.]
Attribute
Don't know
Route
AV8 - STATE ( AVQ1105 )
Refusal
AV8 - STATE ( AVQ1105 )
2:31:23 PM Friday, March 06, 2009
FieldSize:
Min Value:
Max Value:
Mask:
20
Route
AV8 - STATE ( AVQ1105 )
Page 45 of 49
AV8
STATE
Field4:
Cheshire Name:
( AVQ1105 )
tblADDRESS.STATE
Transformed to HOME.MSTATE in Cheshire.
Item Text display:
Display SP's current mailing address state,
tblADDRESS.State, and allow field to be updated.
Item Text:
Label:
Label Position:
STATE:
Left
Field Type:
Type Name:
Answers Allowed:
Drop Down List:
Lookup File:
Lookup File Name:
String
TStateSt
1
No
No
Number Label
1 [Continuous answer.]
Attribute
Don't know
Route
AV8 - ZIPCODE ( AVQ1110 )
Refusal
AV8 - ZIPCODE ( AVQ1110 )
2:31:27 PM Friday, March 06, 2009
FieldSize:
Min Value:
Max Value:
Mask:
2
Route
AV8 - ZIPCODE ( AVQ1110 )
Page 46 of 49
AV8
ZIPCODE
Field5:
Cheshire Name:
( AVQ1110 )
tblADDRESS.ZIPCODE
Transformed to HOME.MZIPCODE in Cheshire.
Item Text display:
Display SP's current mailing address zipcode,
tblADDRESS.Zipcode, and allow field to be updated.
Item Text:
Label:
Label Position:
ZIPCODE:
Left
Field Type:
Type Name:
Answers Allowed:
Drop Down List:
Lookup File:
Lookup File Name:
Integer
TZipcodeInt
1
No
No
Number Label
1 [Continuous answer.]
Attribute
Don't know
Route
BOX AVEND - (AVQ1115 )
Refusal
BOX AVEND - (AVQ1115 )
FieldSize:
Min Value:
Max Value:
Mask:
5
00000
99999
Route
BOX AVEND - (AVQ1115 )
BACKGROUND VARIABLE ASSIGNMENTS
Collect on tblADDRESS where:
tblADDRESS.AddressRnd = current round,
tblADDRESS.AddressType = 'MAIL',,
tblADDRESS.AddressDetail = 'MAIL'.
If Street Address Line 2 is cleared, update SP's current round tblADDRESS.STADDR2 =
empty.
See detailed instructions below.
STAddr2
If AV8 - STADDR2 is cleared, set
tblADDRESS.STADDR2 = empty.
SOFT EDIT CHECKS
HARD EDIT CHECKS
TECHNICAL NOTES
2:31:28 PM Friday, March 06, 2009
Page 47 of 49
AV8
DESIGN NOTES
UPDATING SP'S MAILING ADDRESS.
2:31:28 PM Friday, March 06, 2009
Page 48 of 49
BOX AVEND
BOX AVEND
Page Order # :
110
BOX INSTRUCTIONS
( AVQ1115 )
GO TO NEXT SECTION .
ASSIGNMENTS
TECHNICAL NOTES
DESIGN NOTES
2:31:28 PM Friday, March 06, 2009
Page 49 of 49
File Type | application/pdf |
Author | hubbard_r |
File Modified | 2010-03-30 |
File Created | 0000-00-00 |