HCSC_SS_RPT_CTL (SQL Table)	Index Back
Enable Self-Service Reports Enable Self-Service Reports

HCSC_SS_RPT_CTL

(SQL Table)

Enable Self-Service Reports

Related Language Record: HCSC_SS_CTL_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 REPORT_ID Character(8) VARCHAR2(8) NOT NULL Report Identifier

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

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

5 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description

6 HCSC_SS_GROUP_ID Character(10) VARCHAR2(10) NOT NULL Group ID
Prompt Table: HCSC_SS_RGRP_VW

7 DESCR Character(30) VARCHAR2(30) NOT NULL Description

8 HCSC_SS_SEC_QRY Character(30) VARCHAR2(30) NOT NULL Security Query
Prompt Table: HCSC_SS_QRY_VW

9 SEQ_NUM5 Number(5,0) INTEGER NOT NULL Sequence Number
Default Value: 10

10 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
Prompt Table: MSG_SET_VW

11 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
Prompt Table: MSG_CAT_VW

12 HCSC_SS_RPT_PSWD Character(1) VARCHAR2(1) NOT NULL Password protect (Y/N) flag for enable self-service reports page.
Y/N Table Edit
Default Value: N

13 HCSC_SS_DIGITAL_SG Character(1) VARCHAR2(1) NOT NULL Digital Signature
Y/N Table Edit
Default Value: N

14 PACKAGEROOT Character(30) VARCHAR2(30) NOT NULL Root Package ID
Prompt Table: PSPACKAGROOT_VW

15 QUALIFYPATH Character(127) VARCHAR2(127) NOT NULL Qualified Package/Class Path
Prompt Table: PSPACKAGPATH_VW

16 APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID
Prompt Table: PSPACKAGCLAS_VW

17 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.

18 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
2	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: HCSC_SS_CNTRY_V
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
5	DESCR60	Character(60)	VARCHAR2(60) NOT NULL	Description
6	HCSC_SS_GROUP_ID	Character(10)	VARCHAR2(10) NOT NULL	Group ID Prompt Table: HCSC_SS_RGRP_VW
7	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
8	HCSC_SS_SEC_QRY	Character(30)	VARCHAR2(30) NOT NULL	Security Query Prompt Table: HCSC_SS_QRY_VW
9	SEQ_NUM5	Number(5,0)	INTEGER NOT NULL	Sequence Number Default Value: 10
10	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog. Prompt Table: MSG_SET_VW
11	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog. Prompt Table: MSG_CAT_VW
12	HCSC_SS_RPT_PSWD	Character(1)	VARCHAR2(1) NOT NULL	Password protect (Y/N) flag for enable self-service reports page. Y/N Table Edit Default Value: N
13	HCSC_SS_DIGITAL_SG	Character(1)	VARCHAR2(1) NOT NULL	Digital Signature Y/N Table Edit Default Value: N
14	PACKAGEROOT	Character(30)	VARCHAR2(30) NOT NULL	Root Package ID Prompt Table: PSPACKAGROOT_VW
15	QUALIFYPATH	Character(127)	VARCHAR2(127) NOT NULL	Qualified Package/Class Path Prompt Table: PSPACKAGPATH_VW
16	APPCLASSID	Character(30)	VARCHAR2(30) NOT NULL	Application Class ID Prompt Table: PSPACKAGCLAS_VW
17	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.
18	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.