View • Attachments (0) • Info
| Version | Date | User | Description |
|---|---|---|---|
| 1.0 | 06/30/2009 |  Heather Lo |
Initial Spec |
| 1.1 | 07/01/2009 | Heather Lo, Julie Wingate |
Second Draft of Spec |
| 1.2 | 07/06/2009 | Heather Lo, Julie Wingate |
Third Draft of Spec |
| 2.0 | 07/13/2009 | Heather Lo |
Spec With Some Development Steps Completed |
| 2.1 | 08/03/2009 | Heather Lo |
Spec With Development Steps Completed |
| 3.0 | 10/27/2009 | Heather Lo |
Spec Modified To Include Other Financial Processing Documents (for KFSI-694 Jira) |
| 3.1 | 11/05/2009 | Heather Lo |
Spec With Development Steps Completed |
| 3.2 | 11/09/2009 | Heather Lo |
Removed Pre-Encumbrance Doc |
FRS is currently able to route requisitions for approval based on a combination of object codes and account numbers. This functionality can be reproduced in KFS by using an Object Code's Object Sub-Type Code to determine requisition document routing. It requires an additional route node and a new role that is for reviewing and approving the Object Sub-Type Code routing.
This feature needs to be used in all financial processing e-docs.
--ObjectSubTypeCode KIM role type
INSERT INTO KRIM_TYP_T (KIM_TYP_ID,OBJ_ID,VER_NBR,NM,SRVC_NM,ACTV_IND,NMSPC_CD)
VALUES ('71',SYS_GUID(),1,'Object Sub-Type & Document Type','objectSubTypeCodeRoleTypeService','Y','KFS-COA');
--Object Sub Type Code Reviewer role
INSERT INTO KRIM_ROLE_T (ROLE_ID,OBJ_ID,VER_NBR,ROLE_NM,NMSPC_CD,DESC_TXT,KIM_TYP_ID,ACTV_IND,LAST_UPDT_DT)
VALUES ('1003',SYS_GUID(),1,'Object Sub Type Code Reviewer','KFS-SYS',null,'71','Y',null);
--Object Sub Type Code responsibility
INSERT INTO KRIM_RSP_T (RSP_ID,OBJ_ID,VER_NBR,RSP_TMPL_ID,NM,DESC_TXT,ACTV_IND,NMSPC_CD)
VALUES ('1004',SYS_GUID(),1,'1','Review',null,'Y','KFS-SYS');
--Object Sub Type Code responsibility attributes
INSERT INTO KRIM_RSP_ATTR_DATA_T (ATTR_DATA_ID,OBJ_ID,VER_NBR,RSP_ID,KIM_TYP_ID,KIM_ATTR_DEFN_ID,ATTR_VAL)
VALUES ('1024',SYS_GUID(),1,'1004','71','13','KFS');
INSERT INTO KRIM_RSP_ATTR_DATA_T (ATTR_DATA_ID,OBJ_ID,VER_NBR,RSP_ID,KIM_TYP_ID,KIM_ATTR_DEFN_ID,ATTR_VAL)
VALUES ('1025',SYS_GUID(),1,'1004','71','16','ObjectSubTypeCode');
INSERT INTO KRIM_RSP_ATTR_DATA_T (ATTR_DATA_ID,OBJ_ID,VER_NBR,RSP_ID,KIM_TYP_ID,KIM_ATTR_DEFN_ID,ATTR_VAL)
VALUES ('1026',SYS_GUID(),1,'1004','71','40','true');
INSERT INTO KRIM_RSP_ATTR_DATA_T (ATTR_DATA_ID,OBJ_ID,VER_NBR,RSP_ID,KIM_TYP_ID,KIM_ATTR_DEFN_ID,ATTR_VAL)
VALUES ('1027',SYS_GUID(),1,'1004','71','41','true');
--Object Sub Type Code: link the roles and the responsibilities
INSERT INTO KRIM_ROLE_RSP_T (ROLE_RSP_ID,OBJ_ID,VER_NBR,ROLE_ID,RSP_ID,ACTV_IND)
VALUES ('100004',SYS_GUID(),1,'1003','1004','Y');
--Create ObjectSubTypeCode attribute
insert into KRIM_ATTR_DEFN_T(KIM_ATTR_DEFN_ID,OBJ_ID,VER_NBR,NM,ACTV_IND,LBL,NMSPC_CD,CMPNT_NM,APPL_URL)
values('91',SYS_GUID(),1,'financialObjectSubTypeCode','Y','Object Sub Type Code','KFS-COA','edu.arizona.kfs.sys.identity.ArizonaKfsKimAttributes','${application.url}');
--Create mapping between "Object Sub-Type & Document Type KIM role type" and ObjectSubTypeCode attribute
insert into KRIM_TYP_ATTR_T(KIM_TYP_ATTR_ID,OBJ_ID,VER_NBR,KIM_TYP_ID,KIM_ATTR_DEFN_ID,ACTV_IND,SORT_CD)
values('200',SYS_GUID(),1,'71','91','Y','a');
--Create mapping between "Object Sub-Type & Document Type KIM role type" and documentTypeName attribute
insert into KRIM_TYP_ATTR_T(KIM_TYP_ATTR_ID,OBJ_ID,VER_NBR,KIM_TYP_ID,KIM_ATTR_DEFN_ID,ACTV_IND,SORT_CD)
values('201',SYS_GUID(),1,'71','13','Y','b');
|
Browse Space |
Explore Confluence |
Your Account |
Add Content |