DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.US_GOV_CONDUCT_PERFORMANCE

Object Details
Object Name: US_GOV_CONDUCT_PERFORMANCE
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ANALYSIS_CRITERIA_ID NUMBER (15) Yes
ADVERSE_ACTION_NOAC VARCHAR2 (150)
CAUSE_OF_DISCIPLINARY_ACTION VARCHAR2 (150)
DATE_OF_ADVERSE_ACTION DATE

DAYS_SUSPENDED VARCHAR2 (150)
DATE_SUSPENSION_OVER_30_DAYS DATE

DATE_SUSPENSION_UNDER_30_DAYS DATE

PIP_ACTION_TAKEN VARCHAR2 (150)
PIP_BEGINNING_DATE DATE

PIP_ENDING_DATE DATE

PIP_EXTENSIONS VARCHAR2 (150)
PIP_LENGTH VARCHAR2 (150)
PROGRAM_ID NUMBER (15)
ENABLED_FLAG VARCHAR2 (1) Yes
LAST_UPDATE_DATE DATE

CREATION_DATE DATE

PROGRAM_APPLICATION_ID NUMBER (15)
END_DATE_ACTIVE DATE

CREATED_BY NUMBER (15)
REQUEST_ID NUMBER (15)
LAST_UPDATED_BY NUMBER (15)
START_DATE_ACTIVE DATE

LAST_UPDATE_LOGIN NUMBER (15)
OBJECT_VERSION_NUMBER NUMBER (9)
PROGRAM_UPDATE_DATE DATE

SUMMARY_FLAG VARCHAR2 (1) Yes
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      ANALYSIS_CRITERIA_ID
,      ADVERSE_ACTION_NOAC
,      CAUSE_OF_DISCIPLINARY_ACTION
,      DATE_OF_ADVERSE_ACTION
,      DAYS_SUSPENDED
,      DATE_SUSPENSION_OVER_30_DAYS
,      DATE_SUSPENSION_UNDER_30_DAYS
,      PIP_ACTION_TAKEN
,      PIP_BEGINNING_DATE
,      PIP_ENDING_DATE
,      PIP_EXTENSIONS
,      PIP_LENGTH
,      PROGRAM_ID
,      ENABLED_FLAG
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      PROGRAM_APPLICATION_ID
,      END_DATE_ACTIVE
,      CREATED_BY
,      REQUEST_ID
,      LAST_UPDATED_BY
,      START_DATE_ACTIVE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      PROGRAM_UPDATE_DATE
,      SUMMARY_FLAG
FROM APPS.US_GOV_CONDUCT_PERFORMANCE;

Dependencies

[top of page]

APPS.US_GOV_CONDUCT_PERFORMANCE references the following:

SchemaAPPS
SynonymPER_ANALYSIS_CRITERIA

APPS.US_GOV_CONDUCT_PERFORMANCE is not referenced by any database object