1 |
.INCLUDE |
|
|
|
|
0 |
0 |
Remediation plan reporting structure - text |
|
2 |
PL_T |
|
GRFN_REP_RMPLAN_T |
GRFN_REP_TEXT_100 |
CHAR |
100 |
0 |
Remediation Plan |
|
3 |
PL_D |
|
GRFN_REP_RMPLAN_DESCRIPTION |
|
STRG |
0 |
0 |
Remediation Plan Description |
|
4 |
.INCLUDE |
|
|
|
|
0 |
0 |
Texts for Hieararchy |
|
5 |
NODE |
|
GRFN_API_OBJECT_ID |
CHAR50 |
CHAR |
50 |
0 |
Object ID |
|
6 |
NODE_T |
|
GRFN_REP_TREE_TEXT |
GRFN_TEXT |
CHAR |
100 |
0 |
Hierarchy |
|
7 |
NODETYPE |
|
GRFN_API_ENTITY_ID |
GRFN_API_ENTITY_ID |
CHAR |
20 |
0 |
Entity ID |
* |
8 |
NODETYPE_T |
|
GRFN_REP_NODETYPE_TEXT |
GRFN_TEXT |
CHAR |
100 |
0 |
Object Type |
|
9 |
NODETYPE_ICON |
|
GRFN_REP_NODETYPE_ICON |
ICONNAME |
CHAR |
30 |
0 |
Object Type Icon |
|
10 |
.INCLUDE |
|
|
|
|
0 |
0 |
Common hierarchy header |
|
11 |
OBJECT_KEY |
|
GRFN_OBJECT_SEQNR |
|
INT4 |
10 |
0 |
Object Sequence Number |
|
12 |
PARENT_KEY |
|
GRFN_OBJECT_SEQNR |
|
INT4 |
10 |
0 |
Object Sequence Number |
|
13 |
IS_EXPANDED |
|
GRFN_XFLAG |
GRFN_XFLAG |
CHAR |
1 |
0 |
New Input Values |
|
14 |
IS_LEAF |
|
GRFN_XFLAG |
GRFN_XFLAG |
CHAR |
1 |
0 |
New Input Values |
|
15 |
TREE_LEVEL |
|
GRFN_REP_TREE_LEVEL |
INT4 |
INT4 |
10 |
0 |
Tree Level |
|
16 |
.INCLUDE |
|
|
|
|
0 |
0 |
Remediation plan reporting attributes |
|
17 |
PL_CATEGORY_T |
|
GRFN_REP_RMPLAN_CAT_T |
GRFN_REP_CASE_CATEGORY_T |
CHAR |
60 |
0 |
Remediation Plan Type |
|
18 |
PL_STATUS_T |
|
GRFN_REP_RMPLAN_STATUS_T |
GRFN_REP_CASE_STATUS_T |
CHAR |
30 |
0 |
Remediation Plan Status |
|
19 |
PL_CF_STATUS_T |
|
GRFN_REP_RMPLAN_CF_STAT_T |
GRFN_REP_CF_STATUS_T |
CHAR |
60 |
0 |
Remediation Plan Carryforward Status |
|
20 |
PL_CF_TFRAME_T |
|
GRFN_REP_RMPLAN_CF_TFRAME_T |
GRFN_REP_TEXT_40 |
CHAR |
40 |
0 |
Remediation Plan Timeframe Before Carryforward |
|
21 |
PL_PROCESSOR_T |
|
GRFN_REP_RMPLAN_PROC_T |
GRFN_REP_USER_NAME |
CHAR |
80 |
0 |
Remediator |
|
22 |
PL_RESP_USER_T |
|
GRFN_REP_RMPLAN_RESP_T |
GRFN_REP_USER_NAME |
CHAR |
80 |
0 |
Reported by |
|
23 |
PL_CREA_USER_T |
|
GRFN_REP_RMPLAN_CREATED_BY_T |
GRFN_REP_USER_NAME |
CHAR |
80 |
0 |
Remediation Plan Created By |
|
24 |
PL_VAL_USER_T |
|
GRFN_REP_RMPLAN_VALIDATED_BY_T |
GRFN_REP_USER_NAME |
CHAR |
80 |
0 |
Remediation Plan Validated By |
|
25 |
PL_TFRAME_T |
|
GRFN_REP_RMPLAN_TIME_FRAME_T |
GRFN_REP_TEXT_100 |
CHAR |
100 |
0 |
Remediation plan time frame description |
|
26 |
PL_RE_T |
|
GRFN_REP_RMPLAN_REGULATION |
GRFN_REP_TEXT_40 |
CHAR |
40 |
0 |
Remediation plan source regulation text |
|
27 |
PL_OWNER_T |
|
GRFN_REP_RMPLAN_OWNER_T |
GRFN_REP_USER_NAME |
CHAR |
80 |
0 |
Remediation plan owner |
|
28 |
.INCLUDE |
|
|
|
|
0 |
0 |
|
|
29 |
.INCLUDE |
|
|
|
|
0 |
0 |
Remediation plan reporting attributes |
|
30 |
PL_COMMENT |
|
GRFN_REP_RMPLAN_COMMENT |
|
STRG |
0 |
0 |
Remediation Plan Comment |
|
31 |
PL_VAL_COMM |
|
GRFN_REP_RMPLAN_VAL_COMMENT |
|
STRG |
0 |
0 |
Remediation plan - validation comment |
|
32 |
PLAN_INDEX_T |
|
|
|
STRG |
0 |
0 |
|
|
33 |
PLAN_ID |
|
SCMG_CASE_GUID |
SYSUUID_C |
CHAR |
32 |
0 |
Technical Case Key (Case GUID) |
|
34 |
PLAN_NAME |
|
SCMG_CASE_TITLE |
TEXT80 |
CHAR |
80 |
0 |
Case Title |
|
35 |
PROCESSOR |
|
GRPC_DS_FULLNAME |
|
CHAR |
120 |
0 |
Full name |
|
36 |
RESPONSIBLE |
|
GRPC_DS_FULLNAME |
|
CHAR |
120 |
0 |
Full name |
|
37 |
STATUS_TEXT |
|
J_TXT30 |
TEXT30 |
CHAR |
30 |
0 |
Object status |
|
38 |
STARTDATE |
|
BEGDATUM |
DATUM |
DATS |
8 |
0 |
Start Date |
|
39 |
ENDDATE |
|
ENDDATUM |
DATUM |
DATS |
8 |
0 |
End Date |
|
40 |
DESCRIPTION |
|
GRPC_DS_DESCRIPTION |
|
STRG |
0 |
0 |
Description (long text) |
|
41 |
COMMENTS |
|
GRPC_DS_COMMENTS |
|
STRG |
0 |
0 |
Comments |
|
42 |
CREATED_BY |
|
GRPC_DS_FULLNAME |
|
CHAR |
120 |
0 |
Full name |
|
43 |
CREATEDON |
|
DATUM |
DATUM |
DATS |
8 |
0 |
Date |
|
44 |
VALIDATED_ON |
|
DATUM |
DATUM |
DATS |
8 |
0 |
Date |
|
45 |
VALIDATED_BY |
|
GRPC_DS_FULLNAME |
|
CHAR |
120 |
0 |
Full name |
|
46 |
ATTACHMENTS |
|
GRPC_DS_T_ATTACHMENTS |
|
TTYP |
0 |
0 |
|
|
47 |
PL_PROCESSOR |
|
GRFN_REP_RMPLAN_PROC |
XUBNAME |
CHAR |
12 |
0 |
Remediator ID |
* |
48 |
PL_RESP_USER |
|
GRFN_REP_RMPLAN_RESP |
XUBNAME |
CHAR |
12 |
0 |
Reported by ID |
* |
49 |
PL_STATUS |
|
GRFN_REP_RMPLAN_STATUS |
CRM_J_STATUS |
CHAR |
5 |
0 |
Remediation Plan Status ID |
|
50 |
PL_CF_STATUS |
|
GRFN_REP_RMPLAN_CF_STAT |
GRFN_REP_CF_STATUS |
CHAR |
1 |
0 |
Remediation Plan Carryforward Status ID |
|
51 |
PL_DURATION |
|
GRFN_REP_RMPLAN_DURATION |
|
INT4 |
10 |
0 |
Remediation Plan Duration |
|
52 |
PL_DUEDATE |
|
GRFN_REP_RMPLAN_DUEDATE |
|
DATS |
8 |
0 |
Remediation Plan Due Date |
|
53 |
PL_COMPLETION |
|
GRFN_REP_RMPLAN_COMPLETION |
GRFN_PL_COMPLETION |
NUMC |
3 |
0 |
Remediation Plan Completion |
|
54 |
PL_CF_TFRAME |
|
GRFN_REP_RMPLAN_CF_TFRAME |
GRFN_ATTRVALUE |
CHAR |
10 |
0 |
Remediation Plan Timeframe Before Carryforward ID |
|
55 |
PL_CF_YEAR |
|
GRFN_REP_RMPLAN_CF_YEAR |
|
CHAR |
4 |
0 |
Remediation Plan Timeframe Before Carryforward (Year) |
|
56 |
PL_CREA_USER |
|
GRFN_REP_RMPLAN_CREATED_BY |
XUBNAME |
CHAR |
12 |
0 |
Remediation Plan Created By ID |
* |
57 |
PL_CREA_DATE |
|
GRFN_REP_RMPLAN_CREATED_ON |
|
DATS |
8 |
0 |
Remediation Plan Created On (Date) |
|
58 |
PL_VAL_USER |
|
GRFN_REP_RMPLAN_VALIDATED_BY |
XUBNAME |
CHAR |
12 |
0 |
Remediation Plan Validated By ID |
* |
59 |
PL_VAL_DATE |
|
GRFN_REP_RMPLAN_VALIDATED_ON |
DATUM |
DATS |
8 |
0 |
Remediation Plan Validated On |
|
60 |
PL_REGULATION |
|
GRFN_REP_REGULATION |
NUMC08 |
NUMC |
8 |
0 |
Regulation ID |
|
61 |
PL_CATEGORY |
|
GRFN_REP_RMPLAN_CATEGORY |
CHAR4 |
CHAR |
4 |
0 |
Remediation plan category |
|
62 |
PL_TF_BEGDA |
|
GRFN_REP_RMPLAN_TF_BEGDA |
DATUM |
DATS |
8 |
0 |
Remediation plan start date of the time frame |
|
63 |
PL_TF_ENDDA |
|
GRFN_REP_RMPLAN_TF_ENDDA |
DATUM |
DATS |
8 |
0 |
Remediation plan time frame end date |
|
64 |
PL_TFRAME |
|
GRFN_REP_RMPLAN_TIME_FRAME |
GRFN_ATTRVALUE |
CHAR |
10 |
0 |
Remediation plan time frame |
|
65 |
PL_TF_YEAR |
|
GRFN_REP_RMPLAN_TF_YEAR |
CHAR4 |
CHAR |
4 |
0 |
Remediation plan time frame year |
|
66 |
PL_START_DATE |
|
GRFN_REP_RMPLAN_START_DATE |
DATUM |
DATS |
8 |
0 |
Remediation plan start date |
|
67 |
PL_END_DATE |
|
GRFN_REP_RMPLAN_END_DATE |
DATUM |
DATS |
8 |
0 |
Remediation plan end date |
|