SAP ABAP Table GRFN_S_BI_PL_ATTR (Remediation plan attributes for extraction)

Hierarchy

☛ GRCFND_A (Software Component) GRC Foundation ABAP
   ⤷ GRC (Application Component) Governance, Risk and Compliance
     ⤷ GRFN_EXTRACTION (Package) PC-RM BI Extraction

Basic Data

Table Category	INTTAB	Structure
Structure	GRFN_S_BI_PL_ATTR	Table Relationship Diagram
Short Description	Remediation plan attributes for extraction

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Common part of data source structures
2	.INCLUDE	☐				0	0	Details about extraction
3	SNAPSHOT_ID	☐	GRFN_DM_SNAPSHOT_ID	SYSUUID_C	CHAR	32	0	Datamart - Snapshot ID
4	TIMESTAMP	☐	GRFN_TIMESTAMP	GRFN_TIMESTAMP	DEC	15	0	Time Stamp
5	DB_TABLE	☐	GRFN_TABNAME		CHAR	30	0	Table name
6	.INCLUDE	☐				0	0	Timeframe info for extraction
7	TF_YEAR	☐	GRFN_TF_YEAR	GRFN_TF_YEAR	CHAR	4	0	Timeframe Year
8	TIMEFRAME	☐	GRFN_TIMEFRAME	GRFN_TIMEFRAME	CHAR	10	0	Timeframe	*
9	TF_FREQ	☐	GRFN_TF_FREQUENCY	GRFN_TF_FREQUENCY	CHAR	10	0	Timeframe Frequency	*
10	DATEFROM	☐	GRFN_DATE_FROM	GRFN_DATE_FROM	DATS	8	0	Valid from Date
11	DATETO	☐	GRFN_DATE_TO	GRFN_DATE_TO	DATS	8	0	Valid to Date
12	TF_ID	☐	GRFN_BI_TF_ID	GRFN_BI_TF_ID	CHAR	32	0	Compounded timeframe ID
13	.INCLUDE	☐				0	0	Object info for extraction
14	OBJECT_ID	☐	GRFN_API_OBJECT_ID	CHAR50	CHAR	50	0	Object ID
15	ENTITY_ID	☐	GRFN_API_ENTITY_ID	GRFN_API_ENTITY_ID	CHAR	20	0	Entity ID	*
16	OBJECT_KEY	☐	GRFN_API_TECHNAME_ID	GRFN_API_TECHNAME_ID	CHAR	50	0	Object's technical name
17	SHORT_ENTITY_ID	☐	GRFN_SHORT_ENTITY_ID	CHAR2	CHAR	2	0	Shor Entity ID (used in DM)
18	OBJID	☐	HROBJID	HROBJID	NUMC	8	0	Object ID	*
19	GUID	☐	GRFN_GUID	GRFN_GUID	CHAR	32	0	UUID of the GRC object (char32)
20	RE_ID	☐	GRFN_REP_REGULATION	NUMC08	NUMC	8	0	Regulation ID
21	OU_ID	☐	GRFN_REP_ORGUNIT_ID	NUMC08	NUMC	8	0	Organization ID
22	SP_ID	☐	GRFN_REP_SUBPROCESS_ID	NUMC08	NUMC	8	0	Subprocess ID
23	CN_ID	☐	GRFN_REP_CONTROL_ID		CHAR	9	0	Control ID
24	EC_ID	☐	GRFN_REP_ECONTROL	NUMC08	NUMC	8	0	Indirect ELC ID
25	IS_ID	☐	GRFN_REP_ISSUE_ID	SYSUUID_C	CHAR	32	0	Issue ID
26	.INCLUDE	☐				0	0	Remediation plan reporting attributes
27	PL_PROCESSOR	☐	GRFN_REP_RMPLAN_PROC	XUBNAME	CHAR	12	0	Remediator ID	*
28	PL_RESP_USER	☐	GRFN_REP_RMPLAN_RESP	XUBNAME	CHAR	12	0	Reported by ID	*
29	PL_STATUS	☐	GRFN_REP_RMPLAN_STATUS	CRM_J_STATUS	CHAR	5	0	Remediation Plan Status ID
30	PL_CF_STATUS	☐	GRFN_REP_RMPLAN_CF_STAT	GRFN_REP_CF_STATUS	CHAR	1	0	Remediation Plan Carryforward Status ID
31	PL_DURATION	☐	GRFN_REP_RMPLAN_DURATION		INT4	10	0	Remediation Plan Duration
32	PL_DUEDATE	☐	GRFN_REP_RMPLAN_DUEDATE		DATS	8	0	Remediation Plan Due Date
33	PL_COMPLETION	☐	GRFN_REP_RMPLAN_COMPLETION	GRFN_PL_COMPLETION	NUMC	3	0	Remediation Plan Completion
34	PL_CF_TFRAME	☐	GRFN_REP_RMPLAN_CF_TFRAME	GRFN_ATTRVALUE	CHAR	10	0	Remediation Plan Timeframe Before Carryforward ID
35	PL_CF_YEAR	☐	GRFN_REP_RMPLAN_CF_YEAR		CHAR	4	0	Remediation Plan Timeframe Before Carryforward (Year)
36	PL_CREA_USER	☐	GRFN_REP_RMPLAN_CREATED_BY	XUBNAME	CHAR	12	0	Remediation Plan Created By ID	*
37	PL_CREA_DATE	☐	GRFN_REP_RMPLAN_CREATED_ON		DATS	8	0	Remediation Plan Created On (Date)
38	PL_CREA_DATE_TM	☐	GRFN_REP_RMPLAN_CREATED_ON_TM		TIMS	6	0	Remediation Plan Created On (Time)
39	PL_CHANGED_ON	☐	GRFN_REP_RMPLAN_CHANGED_ON		DATS	8	0	Remediation Plan Changed On (Date)
40	PL_CHANGED_ON_TM	☐	GRFN_REP_RMPLAN_CHANGED_ON_TM		TIMS	6	0	Remediation Plan Changed On (Time)
41	PL_CLOSED_ON	☐	GRFN_REP_RMPLAN_CLOSED_ON		DATS	8	0	Remediation Plan Closed On (Date)
42	PL_CLOSED_ON_TM	☐	GRFN_REP_RMPLAN_CLOSED_ON_TM		TIMS	6	0	Remediation Plan Closed On (Time)
43	PL_VAL_USER	☐	GRFN_REP_RMPLAN_VALIDATED_BY	XUBNAME	CHAR	12	0	Remediation Plan Validated By ID	*
44	PL_VAL_DATE	☐	GRFN_REP_RMPLAN_VALIDATED_ON	DATUM	DATS	8	0	Remediation Plan Validated On
45	PL_RE	☐	GRFN_REP_RMPLAN_REGULATION_ID	NUMC08	NUMC	8	0	Remediation plan source regulation ID
46	PL_CATEGORY	☐	GRFN_REP_RMPLAN_CATEGORY	CHAR4	CHAR	4	0	Remediation plan category
47	PL_TF_BEGDA	☐	GRFN_REP_RMPLAN_TF_BEGDA	DATUM	DATS	8	0	Remediation plan start date of the time frame
48	PL_TF_ENDDA	☐	GRFN_REP_RMPLAN_TF_ENDDA	DATUM	DATS	8	0	Remediation plan time frame end date
49	PL_TFRAME	☐	GRFN_REP_RMPLAN_TIME_FRAME	GRFN_ATTRVALUE	CHAR	10	0	Remediation plan time frame
50	PL_TF_YEAR	☐	GRFN_REP_RMPLAN_TF_YEAR	CHAR4	CHAR	4	0	Remediation plan time frame year
51	PL_START_DATE	☐	GRFN_REP_RMPLAN_START_DATE	DATUM	DATS	8	0	Remediation plan start date
52	PL_END_DATE	☐	GRFN_REP_RMPLAN_END_DATE	DATUM	DATS	8	0	Remediation plan end date
53	PL_OWNER	☐	GRFN_REP_RMPLAN_OWNER	XUBNAME	CHAR	12	0	Remediation plan Owner ID	*
54	.INCLUDE	☐				0	0
55	CASE_CLOSED	☐	GRFN_BI_CASE_CLOSED	GRFN_XFELD	CHAR	1	0	Closed cases
56	REMED_STARTED	☐	GRFN_BI_REMED_STARTED	GRFN_XFELD	CHAR	1	0	Remediation started
57	CN_HR_ID	☐	GRFN_BI_CN_HR_ID	HROBJID	NUMC	8	0	Control ID	*
58	AS_ID	☐	GRFN_REP_ASSMNT_ID	SYSUUID_C	CHAR	32	0	Assessment Id
59	TL_ID	☐	GRFN_REP_TESTLOG	SYSUUID_C	CHAR	32	0	Test Log ID

History

Last changed by/on	SAP	20141106
SAP Release Created in	300