HCSC_SS_RPT_CON (SQL Table)	Index Back
Configure Self Service Reports Configure Self Service Reports

HCSC_SS_RPT_CON

(SQL Table)

Configure Self Service Reports

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 REPORT_ID Character(8) VARCHAR2(8) NOT NULL Report Identifier
Prompt Table: HCSC_SS_RID_VW

2 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: HCSC_SS_RCNT_VW

3 REPORT_DEFN_ID Character(12) VARCHAR2(12) NOT NULL Report Name (see PSXPRPTDEFN).
Prompt Table: HCSC_SS_XRPT_VW

4 DS_ID Character(30) VARCHAR2(30) NOT NULL Data Source ID
Prompt Table: PSQRYDEFN_PVW

5 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
Prompt Table: HCSC_SS_RBND_VW

6 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

7 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	REPORT_ID	Character(8)	VARCHAR2(8) NOT NULL	Report Identifier Prompt Table: HCSC_SS_RID_VW
2	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: HCSC_SS_RCNT_VW
3	REPORT_DEFN_ID	Character(12)	VARCHAR2(12) NOT NULL	Report Name (see PSXPRPTDEFN). Prompt Table: HCSC_SS_XRPT_VW
4	DS_ID	Character(30)	VARCHAR2(30) NOT NULL	Data Source ID Prompt Table: PSQRYDEFN_PVW
5	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD). Prompt Table: HCSC_SS_RBND_VW
6	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
7	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.