[Home] [Help] [Dependency Information]
Object Name: | PSP_REPORT_TEMPLATES_H |
---|---|
Object Type: | TABLE |
Owner: | PSP |
FND Design Data: | PSP.PSP_REPORT_TEMPLATES_H |
Subobject Name: | |
Status: | VALID |
Stores history details of Effort report template
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PSP_REPORT_TEMPLATES_H_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | REQUEST_ID |
PSP_REPORT_TEMPLATES_H_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TEMPLATE_ID |
PSP_REPORT_TEMPLATES_H_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | INITIATOR_PERSON_ID |
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 |
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;
PSP.PSP_REPORT_TEMPLATES_H does not reference any database object
PSP.PSP_REPORT_TEMPLATES_H is referenced by following:
|
|
|