Skip to content

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

TABLE: PSP.PSP_REPORT_TEMPLATES_H

Object Details
Object Name: PSP_REPORT_TEMPLATES_H
Object Type: TABLE
Owner: PSP
FND Design Data: TablePSP.PSP_REPORT_TEMPLATES_H
Subobject Name:
Status: VALID


Stores history details of Effort report template


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PSP_REPORT_TEMPLATES_H_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUEST_ID
PSP_REPORT_TEMPLATES_H_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTEMPLATE_ID
PSP_REPORT_TEMPLATES_H_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnINITIATOR_PERSON_ID
Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER (15) Yes Request Id
TEMPLATE_ID NUMBER (15) Yes Template Identifier
TEMPLATE_NAME VARCHAR2 (240) Yes Template Name
BUSINESS_GROUP_ID NUMBER (15) Yes Business group id
SET_OF_BOOKS_ID NUMBER (15) Yes Set of books id
REPORT_TYPE VARCHAR2 (30) Yes Report Type (AWD - Award Type, ER - Effort report)
PERIOD_FREQUENCY_ID NUMBER
Yes Foreign key to PSP_REPORT_PERIOD_FREQUENCY_B
REPORT_TEMPLATE_CODE VARCHAR2 (80) Yes Report template code
DISPLAY_ALL_EMP_DISTRIB_FLAG VARCHAR2 (1)
Flag
MANUAL_ENTRY_OVERRIDE_FLAG VARCHAR2 (1)
Flag
APPROVAL_TYPE VARCHAR2 (30) Yes Approval Type
CUSTOM_APPROVAL_CODE VARCHAR2 (30)
Custom Approval Code
SUP_LEVELS NUMBER

Supervisor levels
PREVIEW_EFFORT_REPORT_FLAG VARCHAR2 (1)
Preview effort report flag
NOTIFICATION_REMINDER_IN_DAYS NUMBER

Notification reminder in days
PARAMETER_NAME_1 VARCHAR2 (150)
Parameter Name
PARAMETER_NAME_2 VARCHAR2 (150)
Parameter Name
PARAMETER_NAME_3 VARCHAR2 (150)
Parameter Name
PARAMETER_NAME_4 VARCHAR2 (150)
Parameter Name
PARAMETER_NAME_5 VARCHAR2 (150)
Parameter Name
PARAMETER_NAME_6 VARCHAR2 (150)
Parameter Name
PARAMETER_NAME_7 VARCHAR2 (150)
Parameter Name
PARAMETER_NAME_8 VARCHAR2 (150)
Parameter Name
PARAMETER_NAME_9 VARCHAR2 (150)
Parameter Name
PARAMETER_NAME_10 VARCHAR2 (150)
Parameter Name
PARAMETER_NAME_11 VARCHAR2 (150)
Parameter Name
PARAMETER_NAME_12 VARCHAR2 (150)
Parameter Name
PARAMETER_NAME_13 VARCHAR2 (150)
Parameter Name
PARAMETER_NAME_14 VARCHAR2 (150)
Parameter Name
PARAMETER_NAME_15 VARCHAR2 (150)
Parameter Name
PARAMETER_NAME_16 VARCHAR2 (150)
Parameter Name
PARAMETER_NAME_17 VARCHAR2 (150)
Parameter Name
PARAMETER_NAME_18 VARCHAR2 (150)
Parameter Name
PARAMETER_NAME_19 VARCHAR2 (150)
Parameter Name
PARAMETER_NAME_20 VARCHAR2 (150)
Parameter Name
PARAMETER_VALUE_1 VARCHAR2 (150)
Parameter Value
PARAMETER_VALUE_2 VARCHAR2 (150)
Parameter Value
PARAMETER_VALUE_3 VARCHAR2 (150)
Parameter Value
PARAMETER_VALUE_4 VARCHAR2 (150)
Parameter Value
PARAMETER_VALUE_5 VARCHAR2 (150)
Parameter Value
PARAMETER_VALUE_6 VARCHAR2 (150)
Parameter Value
PARAMETER_VALUE_7 VARCHAR2 (150)
Parameter Value
PARAMETER_VALUE_8 VARCHAR2 (150)
Parameter Value
PARAMETER_VALUE_9 VARCHAR2 (150)
Parameter Value
PARAMETER_VALUE_10 VARCHAR2 (150)
Parameter Value
PARAMETER_VALUE_11 VARCHAR2 (150)
Parameter Value
PARAMETER_VALUE_12 VARCHAR2 (150)
Parameter Value
PARAMETER_VALUE_13 VARCHAR2 (150)
Parameter Value
PARAMETER_VALUE_14 VARCHAR2 (150)
Parameter Value
PARAMETER_VALUE_15 VARCHAR2 (150)
Parameter Value
PARAMETER_VALUE_16 VARCHAR2 (150)
Parameter Value
PARAMETER_VALUE_17 VARCHAR2 (150)
Parameter Value
PARAMETER_VALUE_18 VARCHAR2 (150)
Parameter Value
PARAMETER_VALUE_19 VARCHAR2 (150)
Parameter Value
PARAMETER_VALUE_20 VARCHAR2 (150)
Parameter Value
SUBMISSION_DATE DATE
Yes Report Submission date
INITIATOR_PERSON_ID NUMBER (9) Yes Initiator Person
INITIATOR_FILE_ID NUMBER (9)
PDF File as seen by the initiator
INITIATOR_ACCEPT_FLAG VARCHAR2 (1)
Initiator Accept Flag
FINAL_RECIPIENTS_FILE_ID NUMBER (9)
PDF as seen by the Final Recipients
SPRCD_TOLERANCE_AMT NUMBER

Supercede Tolerance Amount
SPRCD_TOLERANCE_PERCENT NUMBER

Supercede Tolerance percent
DESCRIPTION VARCHAR2 (240)
Description
LEGISLATION_CODE VARCHAR2 (30)
Legislation code
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard Who Column
CREATED_BY NUMBER (15) Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
PAYROLL_ACTION_ID NUMBER (9)
Foreign key to PAY_PAYROLL_ACTIONS
FINAL_RECIP_NOTIFIED_FLAG VARCHAR2 (1)
Flag
HUNDRED_PCENT_EFF_AT_PER_ASG VARCHAR2 (1) Yes 100% effort at person/assignment level
INITIATOR_WF_ITEM_KEY VARCHAR2 (240)
Initiator process wf item key
SELECTION_MATCH_LEVEL VARCHAR2 (3) Yes Selection Match Level
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 does not reference any database object

PSP.PSP_REPORT_TEMPLATES_H is referenced by following:

SchemaPSP
ViewPSP_REPORT_TEMPLATES_H#