Requests
Field Name |
Caption |
Mask |
Description |
Field Type |
RQ_ACCOUNT |
Account # |
20x |
Account # |
Text |
RQ_ADESC1 |
Desc 1 |
255x |
Description 1 for Asset |
Text |
RQ_ADESC2 |
Desc 2 |
255x |
Description 2 for Asset |
Text |
RQ_ADR_APT |
Req Apt./Suite |
25x |
Requestor's Apartment/Suite |
Text |
RQ_ADR_B2 |
Req Street Post Bldg No |
8x |
Street Post Building No |
Text |
RQ_ADR_B22 |
Req Street 2 Post Bldg No |
8x |
Street Post Building No 2 |
Text |
RQ_ADR_BDG |
Req Address |
nnnnnn |
Requestor's Address - Building Number |
Long Integer |
RQ_ADR_DIR |
Req Street Direction |
2x |
Requestor's Address - Direction |
Text |
RQ_ADR_PT |
Req Street Prefix Type |
5x |
Req Street Prefix Type |
Text |
RQ_ADR_SFX |
Req Street Suffix |
5x |
Requestor's Address - Suffix |
Text |
RQ_ADR_STR |
Req Street Name |
50x |
Requestor's Address - Street Name |
Text |
RQ_ADR_TY |
Req Street Type |
5x |
Requestor's Address - Street Type |
Text |
RQ_ADR2_PT |
Req Street 2 Prefix Type |
5x |
Req Street 2 Prefix Type |
Text |
RQ_ADRBDG2 |
Req Address 2 |
nnnnnn |
Requestor Building 2 |
Long Integer |
RQ_ADRDIR2 |
Street 2 |
2x |
Req Street Direction 2 |
Text |
RQ_ADRSFX2 |
Req Street Suffix 2 |
5x |
Req Street Suffix 2 |
Text |
RQ_ADRSTR2 |
Req Street Name 2 |
50x |
Req Street Name 2 |
Text |
RQ_ADRTY2 |
Req Street Type 2 |
5x |
Req Street Type 2 |
Text |
RQ_AREA_CD |
Area |
10x |
Area Code |
Text |
RQ_AREA_TY |
Area Text |
40x |
Area Description |
Text |
RQ_AZONE_CD |
Alternate Zone |
10x |
Alternate Zone |
String |
RQ_AZONE_TY |
Alternate Zone Desc |
60x |
Alternate Zone Desc |
String |
RQ_BILL |
Send to WO Billing |
|
Send to WO Billing |
Boolean |
RQ_BLDG_CD |
Req Bldg Type |
nnn |
Building Type |
Integer |
RQ_BLDG_TY |
Req Bldg Type Text |
50x |
Building Type Text |
Text |
RQ_BUSNAME |
Business |
50x |
Business Name |
Text |
RQ_CAT_CD |
Category |
10x |
Category |
Text |
RQ_CAT_TY |
Category Text |
60x |
Category Text |
Text |
RQ_CAUS_CD |
Cause |
10x |
Cause |
Text |
RQ_CAUS_TY |
Cause Text |
40x |
Cause Text |
Text |
RQ_CITY |
Req City |
25x |
Req City |
Text |
RQ_CITY_CD |
|
|
Facility |
Integer |
RQ_CITY_TY |
|
50x |
Facility Text |
Text |
RQ_CITYL_CD |
City Location |
nnn |
City Location |
Integer |
RQ_CITYL_TY |
City Location Text |
40x |
City Location Text |
Text |
RQ_COUNTRY |
Req Country |
15x |
Requestor's Country |
Text |
RQ_CREW_CD |
Assigned Crew |
10x |
Crew |
Text |
RQ_CREW_TY |
Assigned Crew Text |
25x |
Crew Text |
Text |
RQ_CRT_BY |
Created By |
25x |
Created By |
Text |
RQ_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
RQ_CT_ID |
Category Rec # |
nnnnnnnn |
Long Integer |
|
RQ_CUR_RD1 |
|
|
Current Read |
Double |
RQ_CUR_RD2 |
|
|
Current Read |
Double |
RQ_CUR_RD3 |
|
|
Current Read |
Double |
RQ_DEPT_CD |
Department |
10x |
Department |
Text |
RQ_DEPT_TY |
Department Text |
50x |
Department Text |
Text |
RQ_DEVICEID |
Device ID |
150x |
DeviceID for mobile entries |
Text |
RQ_DIV_CD |
Division |
10x |
Division Code |
Text |
RQ_DIV_TY |
Division Text |
40x |
Division Description |
Text |
RQ_DND |
Do Not Disclose |
|
Do Not Disclose |
Boolean |
RQ_DOC_FLG |
Document Available |
|
Doc Available: Doc Flag |
Boolean |
RQ_EMAIL |
150x |
Email address |
Text |
|
RQ_EXTERNALID |
External Request ID |
100x |
External 3rd Party Client ID |
Text |
RQ_FLLW_DT |
Follow-Up Date |
mm/dd/yyyy |
Follow-Up Date |
Date/Time |
RQ_GENLOC |
General Location |
200x |
General Location |
Text |
RQ_HM_PHN |
Home Phone # |
25x |
Home Phone # |
Text |
RQ_ID |
Request Rec # |
nnnnnnnn |
Unique ID |
Long Integer |
RQ_IMG_FLG |
|
|
Image Available |
Boolean |
RQ_INFR_ID |
Asset Rec # |
-nnnnnnnn |
Link to **_ID field on the selected Asset module. |
Long Integer |
RQ_INV_ID |
Inventory Type ID |
-nnnnnnnn |
Link to WKCATINV.CI_ID - Lucity System Category |
Long Integer |
RQ_LASTDT |
Last Request Date |
mm/dd/yyyy |
Last Request Date |
Date/Time |
RQ_LASTTM |
Last Request Time |
hh:mm am |
Last Request Time |
Date/Time |
RQ_LINK1 |
Affected Asset |
150x |
Asset Common Man's ID # 1 |
Text |
RQ_LINK2 |
Affected Asset 2 |
150x |
Asset Common Man's ID # 2 |
Text |
RQ_LOC_APT |
Loc Apt./Suite |
25x |
Location Apartment/ Suite |
Text |
RQ_LOC_B2 |
Loc Post Bldg No |
8x |
Loc Post Building No |
Text |
RQ_LOC_B22 |
Loc 2 Post Bldg No |
8x |
Loc Post Building No 2 |
Text |
RQ_LOC_BDC |
Building Type |
nnn |
Location Building Type |
Integer |
RQ_LOC_BDG |
Loc Address |
nnnnnn |
Location Address - Building Number |
Long Integer |
RQ_LOC_BDT |
Building Type Text |
50x |
Location Building Type Text |
Text |
RQ_LOC_CNY |
Loc Country |
15x |
Location Country |
Text |
RQ_LOC_CTY |
Loc City |
25x |
Locaiton City |
Text |
RQ_LOC_DIR |
Loc Street Direction |
2x |
Location Address - Direction |
Text |
RQ_LOC_PARCEL |
Loc Parcel Number |
40x |
Loc Parcel |
Text |
RQ_LOC_PST |
Loc Zip Code |
15x |
Location Postal Code |
Text |
RQ_LOC_PT |
Loc Prefix Type |
5x |
Loc Street Prefix Type |
Text |
RQ_LOC_SFX |
Loc Street Suffix |
5x |
Location Address - Suffix |
Text |
RQ_LOC_ST |
Loc State |
25x |
Location State |
Text |
RQ_LOC_STR |
Loc Street Name |
50x |
Location Address - Street Name |
Text |
RQ_LOC_TY |
Loc Street Type |
5x |
Location Address - Street Type |
Text |
RQ_LOC2_PT |
Loc 2 Prefix Type |
5x |
Loc Street 2 Prefix Type |
Text |
RQ_LOCBDG2 |
Loc Street2 |
nnnnnn |
Loc Address : Building Number |
Long Integer |
RQ_LOCDIR2 |
Loc Street2 Direct |
2x |
Loc Street2 Direction : |
Text |
RQ_LOCSFX2 |
Loc Street2 Suffix |
5x |
Loc Street2 Suffix : |
Text |
RQ_LOCSTR2 |
Loc Street2 Name |
50x |
Loc Street2 Name : |
Text |
RQ_LOCTY2 |
Loc Street2 Type |
5x |
Loc Street2 Type : |
Text |
RQ_MOD_BY |
Last Modified By |
25x |
Modified By |
Text |
RQ_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Modified Date |
Date/Time |
RQ_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
RQ_MOV_FLG |
|
|
Movie Available |
Boolean |
RQ_MTR_DT |
|
|
Meter Read Date |
Date/Time |
RQ_MTRDEV |
|
20x |
Meter Device |
Text |
RQ_MW_ID |
Master Work Link |
nnnnnnn |
Master Work Link |
Long Integer |
RQ_MZONE_CD |
Maintenance Zone |
10x |
Maintenance Zone |
String |
RQ_MZONE_TY |
Maintenance Zone Desc |
60x |
Maintenance Zone Desc |
String |
RQ_NAM_MI |
Middle Initial |
1x |
Name, Middle Initial |
Text |
RQ_NAM_SAL |
Salutation |
6x |
Name, Salutation |
Text |
RQ_NAM_SFX |
Name Suffix |
5x |
Name, Suffix (Jr., III) |
Text |
RQ_NAME1 |
Name |
40x |
Name |
Text |
RQ_NAME2 |
Name (2) |
40x |
Name (2) |
Text |
RQ_NAMTYP_CD |
Name Type |
nnnn |
Name Type Code |
Integer |
RQ_NAMTYP_TY |
Name Type Text |
30x |
Name Type Text |
Text |
RQ_NEW_RD1 |
|
|
New Meter Read |
Double |
RQ_NEW_RD2 |
|
|
New Meter Read |
Double |
RQ_NEW_RD3 |
|
|
New Meter Read |
Double |
RQ_NEWMTR |
|
20x |
New Meter Device Number |
Text |
RQ_NUMBER |
Request # |
25x |
Request # |
Text |
RQ_NUMREQ |
No of Requests |
nnn |
No of Requests |
Integer |
RQ_OADDR1 |
Owner Address 1 |
50x |
Owner Address 1 |
Text |
RQ_OADDR2 |
Owner Address 2 |
50x |
Owner Address 2 |
Text |
RQ_OADDR3 |
Owner Address 3 |
50x |
Owner Address 3 |
Text |
RQ_OBUS |
Owner Business |
50x |
Owner Business |
Text |
RQ_OCC_FLG |
Override Customer Compl |
|
Override Customer Completed |
Boolean |
RQ_OEMAIL |
Owner Email |
150x |
Owner Email |
Text |
RQ_ONAME |
Owner Name |
50x |
Owner Name |
Text |
RQ_OOD_FLG |
Override Overdue |
|
Override Overdue Notice |
Boolean |
RQ_OPHONE1 |
Owner Phone 1 |
25x |
Owner Phone 1 |
Text |
RQ_OPHONE2 |
Owner Phone 2 |
25x |
Owner Phone 2 |
Text |
RQ_OPHONE3 |
Owner Phone 3 |
25x |
Owner Phone 3 |
Text |
RQ_OPHONE4 |
Owner Phone 4 |
25x |
Owner Phone 4 |
Text |
RQ_OPN_FLG |
Override Problem Notif |
|
Override Problem Notice |
Boolean |
RQ_OSU_FLG |
Override Supervisor |
|
Override Supervisor Notice |
Boolean |
RQ_OTY_FLG |
Override Thank you |
|
Override Thankyou Notice |
Boolean |
RQ_OWS_FLG |
Override WO Status Changed Notice |
|
Override WO Status Changed Notice |
Boolean |
RQ_PARCEL |
Req Parcel Number |
40x |
Parcel |
Text |
RQ_PHONE |
Phone # |
25x |
Request Phone # |
Text |
RQ_PHONE1 |
Phone 1 |
25x |
Phone 1 |
Text |
RQ_PHONE2 |
Phone 2 |
25x |
Phone 2 |
Text |
RQ_POSTAL |
Req Zip Code |
15x |
Requestor's Postal Code |
Text |
RQ_PROB_CD |
Problem |
10x |
Problem |
Text |
RQ_PROB_TY |
Problem Text |
40x |
Problem Text |
Text |
RQ_PROJSTRTDT |
Projected Start Date |
mm/dd/yyyy hh:mm am |
Projected Start Date |
DateTime |
RQ_PRTY_CD |
Priority |
nnn |
Priority |
Integer |
RQ_PRTY_TY |
Priority Text |
25x |
Priority Text |
Text |
RQ_PUBLIC |
Publically Available |
|
Is this request available for public consumption? |
Boolean |
RQ_REC_BY |
Recorded By |
25x |
Recorded By |
Text |
RQ_REC_DT |
Recorded Date |
mm/dd/yyyy |
Recorded Date |
Date/Time |
RQ_REC_TM |
Recorded Time |
hh:mm am |
Recorded Time |
Date/Time |
RQ_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
RQ_SAREACD |
Sub-Area |
10x |
Sub-Area Code |
Text |
RQ_SAREATY |
Sub-Area Text |
40x |
Sub-Area Description |
Text |
RQ_SDIV_CD |
Sub-Division |
10x |
SubDivision Code |
Text |
RQ_SDIV_TY |
Sub-Division Text |
40x |
SubDivision Description |
Text |
RQ_STAT_CD |
Status |
nnn |
Status |
Integer |
RQ_STAT_DT |
Status Date |
mm/dd/yyyy |
Status Date |
Date/Time |
RQ_STAT_TM |
Status Time |
hh:mm am |
Status Time |
Date/Time |
RQ_STAT_TY |
Status Text |
25x |
Status Text |
Text |
RQ_STATE |
Req State |
25x |
Requestor's State |
Text |
RQ_STRTDTLOCK |
Projected Start Date Lock |
|
Projected Start Date Lock |
Boolean |
RQ_SUPR_CD |
Supervisor |
20x |
Supervisor |
Text |
RQ_SUPR_TY |
Supervisor Text |
40x |
Supervisor Text |
Text |
RQ_TBCOOR |
TB Coordinates |
30x |
TB Coordinates |
Text |
RQ_TBPAGE |
TB Page |
30x |
TB Page |
Text |
RQ_TBYEAR |
TB Year |
30x |
TB Year |
Text |
RQ_TYPE |
Asset Type Text |
50x |
Object Type |
Text |
RQ_USER10 |
User 10 |
mm/dd/yyyy |
User 10 |
Date/Time |
RQ_USER11 |
User 11 |
mm/dd/yyyy |
User 11 |
Date/Time |
RQ_USER12 |
User 12 |
-nnnnnnnnn.nn |
User 12 |
Double |
RQ_USER13 |
User 13 |
-nnnnnnnnn.nn |
User 13 |
Double |
RQ_USER14 |
User 14 |
30x |
User 14 |
Text |
RQ_USER15 |
User 15 |
30x |
User 15 |
Text |
RQ_USER16CD |
User 16 |
nnn |
User 16 |
Integer |
RQ_USER16TY |
User 16 Text |
25x |
User 16 Text |
Text |
RQ_USER17CD |
User 17 |
nnn |
User 17 |
Integer |
RQ_USER17TY |
User 17 Text |
25x |
User 17 Text |
Text |
RQ_USER18CD |
User 18 |
nnn |
User 18 |
Integer |
RQ_USER18TY |
User 18 Text |
25x |
User 18 Text |
Text |
RQ_USER19 |
User 19 |
30x |
User 19 |
Text |
RQ_USER1CD |
User 1 |
nnn |
User 1 |
Integer |
RQ_USER1TY |
User 1 Text |
25x |
User 1 Text |
Text |
RQ_USER20 |
User 20 |
30x |
User 20 |
Text |
RQ_USER21 |
User 21 |
30x |
User 21 |
Text |
RQ_USER22 |
User 22 |
-nnnnnnnnn.nn |
User 22 |
Double |
RQ_USER23 |
User 23 |
-nnnnnnnnn.nn |
User 23 |
Double |
RQ_USER24 |
User 24 |
-nnnnnnnnn.nn |
User 24 |
Double |
RQ_USER25 |
User 25 |
mm/dd/yyyy |
User 25 |
Date/Time |
RQ_USER26 |
User 26 |
mm/dd/yyyy |
User 26 |
Date/Time |
RQ_USER27 |
User 27 |
mm/dd/yyyy |
User 27 |
Date/Time |
RQ_USER28 |
User 28 |
|
User 28 |
Boolean |
RQ_USER29 |
User 29 |
|
User 29 |
Boolean |
RQ_USER2CD |
User 2 |
nnn |
User 2 |
Integer |
RQ_USER2TY |
User 2 Text |
25x |
User 2 Text |
Text |
RQ_USER30 |
User 30 |
|
User 30 |
Boolean |
RQ_USER3CD |
User 3 |
nnn |
User 3 |
Integer |
RQ_USER3TY |
User 3 Text |
25x |
User 3 Text |
Text |
RQ_USER4 |
User 4 |
-nnnnnnnnn.nn |
User 4 |
Double |
RQ_USER5 |
User 5 |
30x |
User 5 |
Text |
RQ_USER6 |
User 6 |
|
User 6 |
Boolean |
RQ_USER7 |
User 7 |
|
User 7 |
Boolean |
RQ_USER8 |
User 8 |
|
User 8 |
Boolean |
RQ_USER9 |
User 9 |
mm/dd/yyyy |
User 9 |
Date/Time |
RQ_WK_PHN |
Work Phone # |
25x |
Work Phone # |
Text |
RQ_WU25DT |
WO User 25 Date |
mm/dd/yyyy |
User 25 Date |
Date/Time |
RQ_WU25TM |
WO User 25 Time |
hh:mm am |
User 25 Time |
Date/Time |
RQ_WUSR10 |
WO User 10 |
mm/dd/yyyy |
User 10 |
Date/Time |
RQ_WUSR11 |
WO User 11 |
mm/dd/yyyy |
User 11 |
Date/Time |
RQ_WUSR12 |
WO User 12 |
-nnnnnnnnn.nn |
User 12 |
Double |
RQ_WUSR13 |
WO User 13 |
-nnnnnnnnn.nn |
User 13 |
Double |
RQ_WUSR14 |
WO User 14 |
30x |
User 14 |
Text |
RQ_WUSR15 |
WO User 15 |
30x |
User 15 |
Text |
RQ_WUSR16C |
WO User 16 |
nnn |
User 16 |
Integer |
RQ_WUSR16T |
WO User 16 Text |
25x |
User 16 Text |
Text |
RQ_WUSR17C |
WO User 17 |
nnn |
User 17 |
Integer |
RQ_WUSR17T |
WO User 17 Text |
25x |
User 17 Text |
Text |
RQ_WUSR18C |
WO User 18 |
nnn |
User 18 |
Integer |
RQ_WUSR18T |
WO User 18 Text |
25x |
User 18 Text |
Text |
RQ_WUSR19C |
WO User 19 |
nnn |
User 19 |
Integer |
RQ_WUSR19T |
WO User 19 Text |
25x |
User 19 Text |
Text |
RQ_WUSR1CD |
WO User 1 |
nnn |
User 1 |
Integer |
RQ_WUSR1TY |
WO User 1 Text |
25x |
User 1 Text |
Text |
RQ_WUSR20C |
WO User 20 |
12x |
User 20 |
Text |
RQ_WUSR20T |
WO User 20 Text |
50x |
User 20 Text |
Text |
RQ_WUSR21C |
WO User 21 |
12x |
User 21 |
Text |
RQ_WUSR21T |
WO User 21 Text |
50x |
User 21 Text |
Text |
RQ_WUSR22 |
WO User 22 |
30x |
User 22 |
Text |
RQ_WUSR23 |
WO User 23 |
-nnnnnnnn.nn |
User 23 |
Double |
RQ_WUSR24 |
WO User 24 |
-nnnnnnnn.nn |
User 24 |
Double |
RQ_WUSR26 |
WO User 26 |
|
User 26 |
Boolean |
RQ_WUSR27 |
WO User 27 |
|
User 27 |
Boolean |
RQ_WUSR28 |
WO User 28 |
|
User 28 |
Boolean |
RQ_WUSR29 |
WO User 29 |
|
User 29 |
Boolean |
RQ_WUSR2CD |
WO User 2 |
nnn |
User 2 |
Integer |
RQ_WUSR2TY |
WO User 2 Text |
25x |
User 2 Text |
Text |
RQ_WUSR30 |
WO User 30 |
|
User 30 |
Boolean |
RQ_WUSR3CD |
WO User 3 |
nnn |
User 3 |
Integer |
RQ_WUSR3TY |
WO User 3 Text |
25x |
User 3 Text |
Text |
RQ_WUSR4 |
WO User 4 |
nnnnnnnnn. |
User 4 |
Double |
RQ_WUSR5 |
WO User 5 |
30x |
User 5 |
Text |
RQ_WUSR50C |
WO User 50 |
12x |
User 50 |
Text |
RQ_WUSR50T |
WO User 50 Text |
50x |
User 50 Text |
Text |
RQ_WUSR51C |
WO User 51 |
12x |
User 51 |
Text |
RQ_WUSR51T |
WO User 51 Text |
50x |
User 51 Text |
Text |
RQ_WUSR6 |
WO User 6 |
|
User 6 |
Boolean |
RQ_WUSR7 |
WO User 7 |
|
User 7 |
Boolean |
RQ_WUSR8 |
WO User 8 |
|
User 8 |
Boolean |
RQ_WUSR9 |
WO User 9 |
mm/dd/yyyy |
User 9 |
Date/Time |
RQ_X_COORD |
Loc X Coord. |
-nnnnnnnnn.nnnnnnnn |
X Coordinate |
Double |
RQ_Y_COORD |
Loc Y Coord. |
-nnnnnnnnn.nnnnnnnn |
Y Coordinate |
Double |