CN_SRP_PLAN_APPR_LINES_ALL
CN_SRP_PLAN_APPR_LINES_ALL contains information about Particpnat Comp Plan assignment records to be submitted for approval in Approval Job request. Need one entry for each Particpnat Comp Plan assignment record to be published.
Details
-
Schema: FUSION
-
Object owner: CN
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CN_SRP_PLAN_APPR_LINES_AL_PK |
SRP_PLAN_APPR_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SRP_PLAN_APPR_LINE_ID | NUMBER | 18 | Yes | Srp Plan Approval Line Identifier - Primary Key | |
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |
| SRP_PLAN_APPR_JOB_ID | NUMBER | 18 | Points to the table cn_srp_plan_appr_jobs_all | ||
| SRP_PLAN_APPR_INSTANCE_ID | NUMBER | 18 | Points to the table cn_srp_plan_appr_instances_all. | ||
| SRP_COMP_PLAN_ID | NUMBER | 18 | Points to the table cn_srp_comp_plans_all | ||
| STATUS | VARCHAR2 | 30 | SRP com plan assignment record publish status. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| CN_SRP_PLAN_APPR_LINES_ALL | cn_srp_comp_plans_all | SRP_COMP_PLAN_ID |
| CN_SRP_PLAN_APPR_LINES_ALL | cn_srp_plan_appr_jobs_all | SRP_PLAN_APPR_JOB_ID |
| CN_SRP_PLAN_APPR_LINES_ALL | cn_srp_plan_appr_instances_all | SRP_PLAN_APPR_INSTANCE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CN_SRP_PLAN_APPR_LINES_N1 | Non Unique | Default | SRP_PLAN_APPR_JOB_ID |
| CN_SRP_PLAN_APPR_LINES_N2 | Non Unique | Default | SRP_PLAN_APPR_INSTANCE_ID |
| CN_SRP_PLAN_APPR_LINES_N3 | Non Unique | Default | SRP_COMP_PLAN_ID |
| CN_SRP_PLAN_APPR_LINES_U1 | Unique | Default | SRP_PLAN_APPR_LINE_ID |