LEVELAPPROVAL
Table Description
| Key | NULL | Column | Type (Size) |
|---|---|---|---|
P |
No |
NUMBER |
|
No |
NUMBER |
||
No |
NUMBER |
||
Yes |
DATE |
||
No |
NUMBER |
||
Yes |
VARCHAR2(255) |
||
F |
Yes |
NUMBER |
|
F |
Yes |
NUMBER |
|
F |
Yes |
NUMBER |
|
Yes |
NUMBER |
||
Yes |
NUMBER(1) |
||
Yes |
DATE |
||
No |
NUMBER |
Column Descriptions
OID
This field contains the sequential number of the Level Request.
All Level Requests defined for a Project are numbered sequentially.
See also: LEVELAPPROVAL_PK.
| Key | NULL | Column | Type (Size) |
|---|---|---|---|
P |
No |
OID |
NUMBER |
STATUS
The Approval Status.
Possible status indications are:
-
Awaiting Approval
-
Awaiting Level Request Finish: This status is assigned to a Post- Approval when a Level Request starts, and is changed to “Awaiting Approval” when the Level Request ends with status Success or Warning.
-
Awaiting Predecessor Approval: this status is assigned to the Approval when a preceding Approval on the Level Request must be granted first.
-
Approved
-
Rejected
-
Canceled: when a previous Level Approval was rejected.
| Key | NULL | Column | Type (Size) |
|---|---|---|---|
No |
STATUS |
NUMBER |
APPROVEDATETIME
The date and time at which the approval was granted or rejected. This field is empty for outstanding approvals.
| Key | NULL | Column | Type (Size) |
|---|---|---|---|
Yes |
APPROVEDATETIME |
DATE |
SEQUENCENUMBER
Number indicating the position of the Approval within the sequence of Approvals associated with the Level.
| Key | NULL | Column | Type (Size) |
|---|---|---|---|
No |
SEQUENCENUMBER |
NUMBER |
REASON
The reason of approval or rejection, as defined by the user. This field is empty for outstanding approvals.
| Key | NULL | Column | Type (Size) |
|---|---|---|---|
Yes |
REASON |
VARCHAR2(255) |
LEVELREQUESTOID
Identifier for the LEVELREQUEST table.
For more information, refer to the description of the foreign key LEVELAPPROVAL_FK_.
See also: LEVELAPPROVAL_FK_1.
| Key | NULL | Column | Type (Size) |
|---|---|---|---|
F |
Yes |
LEVELREQUESTOID |
NUMBER |
APPROVEDBYUSEROID
Identifier for the SCMUSER table.
For more information, refer to the description of the foreign key LEVELAPPROVAL_FK_2.
See also: LEVELAPPROVAL_FK_2.
| Key | NULL | Column | Type (Size) |
|---|---|---|---|
F |
Yes |
APPROVEDBYUSEROID |
NUMBER |
CONTROLLEDBYUSERGROUPOID
Identifier for the USERGROUP table.
For more information, refer to the description of the foreign key LEVELAPPROVAL_FK_3.
See also: LEVELAPPROVAL_FK_3.
| Key | NULL | Column | Type (Size) |
|---|---|---|---|
F |
Yes |
CONTROLLEDBYUSERGROUPOID |
NUMBER |
LEVELREQUESTSTATUSONAPPROVE
The Level Request Status after Approval.
The following status indication icons are possible:
(Success) : the Level Request is executed successfully.
(Warning) : the Level Request has been successfully executed, but at least one non-critical Level, Build or Deploy Phase failed.
(Fail): the execution of the Level Request as a whole failed. This is due to the failure of one or more critical Level, Build or Deploy Phases.
(Run): the Level Request is being executed at this moment.
(Awaiting requested Date/Time): the requested execution is in the future.
(Awaiting Pre-Approval or Awaiting Post-Approval): the Level Request is awaiting a Pre- or Post-Approval.
(Rejected): An Approval associated with the Level Request was rejected. The Level Request will never be executed.
(Canceled): the Level Request has been canceled before it was run. It will never be executed.
(Aborted): the Level Request has been aborted during execution. The results (such as Build Results) that were already available at the time of the abort have been cleaned up and cannot be used.
| Key | NULL | Column | Type (Size) |
|---|---|---|---|
Yes |
LEVELREQUESTSTATUSONAPPROVE |
NUMBER |
Relationships
Referenced Tables
LEVELREQUEST
Refer to the chapter LEVELREQUEST for a detailed description of the table.
| Foreign Key | Referenced Column(s) |
|---|---|
LEVELAPPROVAL_FK_1 |
SCMUSER
Refer to the chapter SCMUSER for a detailed description of the table.
| Foreign Key | Referenced Column(s) |
|---|---|
LEVELAPPROVAL_FK_2 |
Report Labels
LEVELAPPROVAL_APPROVEDATETIME_LABEL
English: |
Approval Date/Time |
French: |
Approuvée/rejetée le |
German: |
Genehmigt/Abgelehnt am |
LEVELAPPROVAL_APPROVEDBYUSEROID_LABEL
English: |
OID |
French: |
OID |
German: |
OID |
LEVELAPPROVAL_ARCHIVED_LABEL
English: |
Archived |
French: |
Archivé(e) |
German: |
Archiviert |
LEVELAPPROVAL_ARCHIVEDDATETIME_LABEL
English: |
Archive Date/Time |
French: |
Date/heure archivage |
German: |
Datum/Zeit Archivierung |
LEVELAPPROVAL_CONTROLLEDBYUSERGROUPOID_LABEL
English: |
OID |
French: |
OID |
German: |
OID |
LEVELAPPROVAL_LEVELREQUESTOID_LABEL
English: |
OID |
French: |
OID |
German: |
OID |
LEVELAPPROVAL_LEVELREQUESTSTATUSONAPPROVE_LABEL
English: |
Status after Approval |
French: |
Situation après approbation |
German: |
Status nach Genehmigung |
LEVELAPPROVAL_OID_LABEL
English: |
OID |
French: |
OID |
German: |
OID |
LEVELAPPROVAL_REASON_LABEL
English: |
Reason |
French: |
Commentaire |
German: |
Grund |
LEVELAPPROVAL_SEQUENCENUMBER_LABEL
English: |
Sequence Number |
French: |
Numéro de séquence |
German: |
Sequenznummer |
LEVELAPPROVAL_STATUS_LABEL
English: |
Status |
French: |
Statut |
German: |
Status |
LEVELAPPROVAL_TYPE_LABEL
English: |
Type |
French: |
Type |
German: |
Typ |
LEVELAPPROVAL_VERSION_LABEL
English: |
Version |
French: |
Version |
German: |
Version |