RQAPPCODE FILE Requisition Approval Codes This file defines an approval process. These codes are assigned to requesters to identify the approval hierarchy for all requisitions entered by that requester. REFERENCED BY DR100 IC141 IC142 IC83.1 RQ04.1 RQ10.1 RQ10.3 RQ11.1 RQ111 RQ12.1 RQ20.1 RQ202 RQ35.1 RQ44.2 RQ500 UPDATED BY RQ02.1 FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY RAC-COMPANY Numeric 4 RQ02.1 Company The company number represents an established company and is entered on all function codes. RAC-APPROVE-CD Alpha 5 RQ02.1 Approval Code This is a user-defined code to identify the approval process (levels) that a requisition has to pass before it can be picked or purchased. RAC-DESCRIPTION Alpha 30 (Lower Case) RQ02.1 Description This is the description of the approval code. RAC-SKIP-LVLS-FL Alpha 1 RQ02.1 Skip Approval This flag indicates whether a higher Levels Flag level approver can approve a requisition before a lower level approver has approved the requisition. Select No if all the levels must approve the requisition in order. Select Yes if upper approval levels can approve the requisition without passing through each prior approval level. N = No Y = Yes RAC-AUTH-PRT-FL Alpha 1 RQ02.1 Authorization Print This flag indicates whether the Flag requisition assigned to this approval code requisitions using this approval code are to be printed in RQ111 (Print Requisitions). When the requisition is entered, this flag defaults onto the requisition. The system determines this by the requester creating the requisition. Every requester is required to have an approval code assigned to it. Defaults to No. N = No Y = Yes RAC-AUTH-ID Alpha 10 Occurs 6 Times RQ02.1 Authorization This is the authorization identifier Identification for the approver to access the requisitions requiring approval at this level. The approver uses this ID to access the requisition information in RQ12.1 (Approval Review). RAC-AUTH-NAME Alpha 30 Occurs 6 Times RQ02.1 Authorization Name This is the header field for the approver names defined for requisition approval levels. RAC-AUTH-LIMIT Numeric 9 Occurs 6 Times RQ02.1 Authorization Limit This is the header field for the authorization limit fields defined for requisition approval levels. RAC-AUTH-NAME1 Derived Auth Name1 This is the name of the person assigned to the first requisition-approval level. The name prints on the requisition when you run RQ111 (Print Requisitions) and displays in RQ44.2 (Requisition Detail Inquiry). Note: Auth Name1 and Auth Limit1 are required; all others (Auth Name2 and Auth Limit2 through Auth Name6 and Auth Limit6) are optional. Unless the Skip Approval Levels flag is set to Yes, the approval process starts with the lowest approval level, which is actually the highest numbered name and limit field. Auth Name1/Auth Limit1 is checked after Name2/Limit2. If you have two levels set up, Name2/Level2 is the lowest level of approval. RAC-AUTH-NAME2 Derived Auth Name2 This is the name of the person assigned to the second requisition-approval level. The name prints on the requisition when you run RQ111 (Print Requisitions) and displays in RQ44.2 (Requisition Detail Inquiry). Note: Auth Name1 and Auth Limit1 are required; all others (Auth Name2 and Auth Limit2 through Auth Name6 and Auth Limit6) are optional. RAC-AUTH-NAME3 Derived Auth Name3 This is the name of the person assigned to the third requisition-approval level. The name prints on the requisition when you run RQ111 (Print Requisitions) and displays in RQ44.2 (Requisition Detail Inquiry). RAC-AUTH-NAME4 Derived Auth Name4 This is the name of the person assigned to the fourth requisition-approval level. The name prints on the requisition when you run RQ111 (Print Requisitions) and displays in RQ44.2 (Requisition Detail Inquiry). RAC-AUTH-NAME5 Derived Auth Name5 This is the name of the person assigned to the fifth requisition-approval level. The name prints on the requisition when you run RQ111 (Print Requisitions) and displays in RQ44.2 (Requisition Detail Inquiry). RAC-AUTH-NAME6 Derived Auth Name6 This is the name of the person assigned to the sixth requisition-approval level. The name prints on the requisition when you run RQ111 (Print Requisitions) and displays in RQ44.2 (Requisition Detail Inquiry). RAC-AUTH-LIMIT1 Derived Auth Limit1 This is the lower limit amount used to compare to the total value of a requisition. The limit is used to determine whether a requisition has to be approved at this level. Note: Auth Name1 and Auth Limit1 are required; all others (Auth Name2 and Auth Limit2 through Auth Name6 and Auth Limit6) are optional. Unless the Skip Approval Levels flag is set to Yes, the approval process starts with the lowest approval level, which is actually the highest numbered name and limit. Auth Name1/Auth Limit1 is checked after Auth Name2/Auth Limit2. If you have two levels set up Auth Name 2/Auth Level2 is the lowest level of approval. RAC-AUTH-LIMIT2 Derived Auth Limit2 This is the lower limit amount used to compare to the total value of a requisition. The limit is used to determine whether a requisition has to be approved at this level. Note: Auth Name1 and Auth Limit1 are required; all others (Auth Name2 and Auth Limit2 through Auth Name6 and Auth Limit6) are optional. The approval process starts with the lowest approval level, which is actually the highest numbered name and limit field. Auth Name1/Auth Limit1 is checked after Auth Name2/Auth Limit2. If you have two levels set up, Auth Name2/Auth Limit2 is the lowest level of approval. RAC-AUTH-LIMIT3 Derived Auth Limit3 This is the lower limit amount used to compare to the total value of a requisition. The limit is used to determine whether a requisition has to be approved at this level. RAC-AUTH-LIMIT4 Derived Auth Limit4 This is the lower limit amount used to compare to the total value of a requisition. The limit is used to determine whether a requisition has to be approved at this level. RAC-AUTH-LIMIT5 Derived Auth Limit5 This is the lower limit amount used to compare to the total value of a requisition. The limit is used to determine whether a requisition has to be approved at this level. RAC-AUTH-LIMIT6 Derived Auth Limit6 This is the lower limit amount used to compare to the total value of a requisition. The limit is used to determine whether a requisition has to be approved at this level. RQAPPCODE FILE INDEX NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN RACSET1 COMPANY Use this index to access a specific DR100 IC141 APPROVE-CD requester approval code record. IC142 IC83.1 RQ02.1 RQ04.1 RQ10.1 RQ10.3 RQ11.1 RQ111 RQ12.1 RQ20.1 RQ202 RQ35.1 RQ44.2 RQ500 RQAPPCODE FILE RELATIONS ONE TO ONE RELATIONS RELATION RELATED NAME FILE INTEGRITY RULES / FIELD MATCH Ic Company ICCOMPANY Required RAC-COMPANY -> ICC-COMPANY |