PJF_BIP_REPORT_DETAIL_GT

PJF table used as a place holder to contain data generated during the process. This data is used to display in BIP Report. Table is used by the PACC development processes.

Details

• Schema: FUSION

• Object owner: PJF

• Object type: TABLE

Primary Key

Name	Columns
PJF_BIP_REPORT_DETAIL_GT_PK	REPORT_NAME, REPORT_LINE_TYPE, REPORT_LINE_NUM

Columns

Name

REPORT_NAMEVARCHAR230YesReport Name ***** REPORT_LINE_TYPEVARCHAR230YesReport Line Type. Example : SUCCESS, ERROR, ERROR_02,SUMMARY_01 etc. ***** REPORT_LINE_NUMNUMBER18YesSerial number of a report for a given report line type. ***** TEXT_COL1VARCHAR280Place holder for a text value ***** TEXT_COL2VARCHAR280Place holder for a text value ***** TEXT_COL3VARCHAR280Place holder for a text value ***** TEXT_COL4VARCHAR280Place holder for a text value ***** TEXT_COL5VARCHAR280Place holder for a text value ***** TEXT_COL6VARCHAR280Place holder for a text value ***** TEXT_COL7VARCHAR280Place holder for a text value ***** TEXT_COL8VARCHAR280Place holder for a text value ***** TEXT_COL9VARCHAR280Place holder for a text value ***** TEXT_COL10VARCHAR280Place holder for a text value ***** TEXT_COL11VARCHAR24000Place holder for a text value ***** TEXT_COL12VARCHAR24000Place holder for a text value ***** TEXT_COL13VARCHAR24000Place holder for a text value ***** TEXT_COL14VARCHAR24000Place holder for a text value ***** TEXT_COL15VARCHAR24000Place holder for a text value ***** TEXT_COL16VARCHAR24000Place holder for a text value ***** TEXT_COL17VARCHAR24000Place holder for a text value ***** NUM_COL1NUMBERPlace holder for a number value ***** NUM_COL2NUMBERPlace holder for a number value ***** NUM_COL3NUMBERPlace holder for a number value ***** NUM_COL4NUMBERPlace holder for a number value ***** NUM_COL5NUMBERPlace holder for a number value ***** NUM_COL6NUMBERPlace holder for a number value ***** NUM_COL7NUMBERPlace holder for a number value ***** NUM_COL8NUMBERPlace holder for a number value ***** NUM_COL9NUMBERPlace holder for a number value ***** NUM_COL10NUMBERPlace holder for a number value ***** DATE_COL1DATEPlace holder for a date value ***** DATE_COL2DATEPlace holder for a date value ***** DATE_COL3DATEPlace holder for a date value ***** DATE_COL4DATEPlace holder for a date value ***** DATE_COL5DATEPlace holder for a date value *****

Indexes

Index	Uniqueness	Columns
PJF_BIP_REPORT_DETAIL_GT_U1	Unique	REPORT_NAME, REPORT_LINE_TYPE, REPORT_LINE_NUM