Skip to content

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

VIEW: PSP.PSP_REPORT_TEMPLATES_H#

Object Details
Object Name: PSP_REPORT_TEMPLATES_H#
Object Type: VIEW
Owner: PSP
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER (15) Yes
TEMPLATE_ID NUMBER (15) Yes
TEMPLATE_NAME VARCHAR2 (240) Yes
BUSINESS_GROUP_ID NUMBER (15) Yes
SET_OF_BOOKS_ID NUMBER (15) Yes
REPORT_TYPE VARCHAR2 (30) Yes
PERIOD_FREQUENCY_ID NUMBER
Yes
REPORT_TEMPLATE_CODE VARCHAR2 (80) Yes
DISPLAY_ALL_EMP_DISTRIB_FLAG VARCHAR2 (1)
MANUAL_ENTRY_OVERRIDE_FLAG VARCHAR2 (1)
APPROVAL_TYPE VARCHAR2 (30) Yes
CUSTOM_APPROVAL_CODE VARCHAR2 (30)
SUP_LEVELS NUMBER

PREVIEW_EFFORT_REPORT_FLAG VARCHAR2 (1)
NOTIFICATION_REMINDER_IN_DAYS NUMBER

PARAMETER_NAME_1 VARCHAR2 (150)
PARAMETER_NAME_2 VARCHAR2 (150)
PARAMETER_NAME_3 VARCHAR2 (150)
PARAMETER_NAME_4 VARCHAR2 (150)
PARAMETER_NAME_5 VARCHAR2 (150)
PARAMETER_NAME_6 VARCHAR2 (150)
PARAMETER_NAME_7 VARCHAR2 (150)
PARAMETER_NAME_8 VARCHAR2 (150)
PARAMETER_NAME_9 VARCHAR2 (150)
PARAMETER_NAME_10 VARCHAR2 (150)
PARAMETER_NAME_11 VARCHAR2 (150)
PARAMETER_NAME_12 VARCHAR2 (150)
PARAMETER_NAME_13 VARCHAR2 (150)
PARAMETER_NAME_14 VARCHAR2 (150)
PARAMETER_NAME_15 VARCHAR2 (150)
PARAMETER_NAME_16 VARCHAR2 (150)
PARAMETER_NAME_17 VARCHAR2 (150)
PARAMETER_NAME_18 VARCHAR2 (150)
PARAMETER_NAME_19 VARCHAR2 (150)
PARAMETER_NAME_20 VARCHAR2 (150)
PARAMETER_VALUE_1 VARCHAR2 (150)
PARAMETER_VALUE_2 VARCHAR2 (150)
PARAMETER_VALUE_3 VARCHAR2 (150)
PARAMETER_VALUE_4 VARCHAR2 (150)
PARAMETER_VALUE_5 VARCHAR2 (150)
PARAMETER_VALUE_6 VARCHAR2 (150)
PARAMETER_VALUE_7 VARCHAR2 (150)
PARAMETER_VALUE_8 VARCHAR2 (150)
PARAMETER_VALUE_9 VARCHAR2 (150)
PARAMETER_VALUE_10 VARCHAR2 (150)
PARAMETER_VALUE_11 VARCHAR2 (150)
PARAMETER_VALUE_12 VARCHAR2 (150)
PARAMETER_VALUE_13 VARCHAR2 (150)
PARAMETER_VALUE_14 VARCHAR2 (150)
PARAMETER_VALUE_15 VARCHAR2 (150)
PARAMETER_VALUE_16 VARCHAR2 (150)
PARAMETER_VALUE_17 VARCHAR2 (150)
PARAMETER_VALUE_18 VARCHAR2 (150)
PARAMETER_VALUE_19 VARCHAR2 (150)
PARAMETER_VALUE_20 VARCHAR2 (150)
SUBMISSION_DATE DATE
Yes
INITIATOR_PERSON_ID NUMBER (9) Yes
INITIATOR_FILE_ID NUMBER (9)
INITIATOR_ACCEPT_FLAG VARCHAR2 (1)
FINAL_RECIPIENTS_FILE_ID NUMBER (9)
SPRCD_TOLERANCE_AMT NUMBER

SPRCD_TOLERANCE_PERCENT NUMBER

DESCRIPTION VARCHAR2 (240)
LEGISLATION_CODE VARCHAR2 (30)
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15) Yes
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
PAYROLL_ACTION_ID NUMBER (9)
FINAL_RECIP_NOTIFIED_FLAG VARCHAR2 (1)
HUNDRED_PCENT_EFF_AT_PER_ASG VARCHAR2 (1) Yes
INITIATOR_WF_ITEM_KEY VARCHAR2 (240)
SELECTION_MATCH_LEVEL VARCHAR2 (3) Yes
Query Text

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


SELECT REQUEST_ID
,      TEMPLATE_ID
,      TEMPLATE_NAME
,      BUSINESS_GROUP_ID
,      SET_OF_BOOKS_ID
,      REPORT_TYPE
,      PERIOD_FREQUENCY_ID
,      REPORT_TEMPLATE_CODE
,      DISPLAY_ALL_EMP_DISTRIB_FLAG
,      MANUAL_ENTRY_OVERRIDE_FLAG
,      APPROVAL_TYPE
,      CUSTOM_APPROVAL_CODE
,      SUP_LEVELS
,      PREVIEW_EFFORT_REPORT_FLAG
,      NOTIFICATION_REMINDER_IN_DAYS
,      PARAMETER_NAME_1
,      PARAMETER_NAME_2
,      PARAMETER_NAME_3
,      PARAMETER_NAME_4
,      PARAMETER_NAME_5
,      PARAMETER_NAME_6
,      PARAMETER_NAME_7
,      PARAMETER_NAME_8
,      PARAMETER_NAME_9
,      PARAMETER_NAME_10
,      PARAMETER_NAME_11
,      PARAMETER_NAME_12
,      PARAMETER_NAME_13
,      PARAMETER_NAME_14
,      PARAMETER_NAME_15
,      PARAMETER_NAME_16
,      PARAMETER_NAME_17
,      PARAMETER_NAME_18
,      PARAMETER_NAME_19
,      PARAMETER_NAME_20
,      PARAMETER_VALUE_1
,      PARAMETER_VALUE_2
,      PARAMETER_VALUE_3
,      PARAMETER_VALUE_4
,      PARAMETER_VALUE_5
,      PARAMETER_VALUE_6
,      PARAMETER_VALUE_7
,      PARAMETER_VALUE_8
,      PARAMETER_VALUE_9
,      PARAMETER_VALUE_10
,      PARAMETER_VALUE_11
,      PARAMETER_VALUE_12
,      PARAMETER_VALUE_13
,      PARAMETER_VALUE_14
,      PARAMETER_VALUE_15
,      PARAMETER_VALUE_16
,      PARAMETER_VALUE_17
,      PARAMETER_VALUE_18
,      PARAMETER_VALUE_19
,      PARAMETER_VALUE_20
,      SUBMISSION_DATE
,      INITIATOR_PERSON_ID
,      INITIATOR_FILE_ID
,      INITIATOR_ACCEPT_FLAG
,      FINAL_RECIPIENTS_FILE_ID
,      SPRCD_TOLERANCE_AMT
,      SPRCD_TOLERANCE_PERCENT
,      DESCRIPTION
,      LEGISLATION_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      PAYROLL_ACTION_ID
,      FINAL_RECIP_NOTIFIED_FLAG
,      HUNDRED_PCENT_EFF_AT_PER_ASG
,      INITIATOR_WF_ITEM_KEY
,      SELECTION_MATCH_LEVEL
FROM PSP.PSP_REPORT_TEMPLATES_H#;

Dependencies

[top of page]

PSP.PSP_REPORT_TEMPLATES_H# references the following:

SchemaPSP
TablePSP_REPORT_TEMPLATES_H
PSP.PSP_REPORT_TEMPLATES_H# is referenced by following:

SchemaAPPS
SynonymPSP_REPORT_TEMPLATES_H