HCSC_SS_RPT_SEC(SQL Table) |
Index Back |
|---|---|
SS Reports Security |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). | |
| 2 | Character(11) | VARCHAR2(11) NOT NULL | Employee ID | |
| 3 | Character(8) | VARCHAR2(8) NOT NULL | Report Identifier | |
| 4 | Character(3) | VARCHAR2(3) NOT NULL | Country | |
| 5 | Character(10) | VARCHAR2(10) NOT NULL | Group ID | |
| 6 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |
| 7 | SEQ_NUM5 | Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 8 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 9 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 10 | ENABLED | Character(1) | VARCHAR2(1) NOT NULL |
A flag indicates whether this row is enabled or not.
Y/N Table Edit |
| 11 | HCSC_SS_DIGITAL_SG | Character(1) | VARCHAR2(1) NOT NULL | Digital Signature |
| 12 | PACKAGEROOT | Character(30) | VARCHAR2(30) NOT NULL |
Root Package ID
Prompt Table: PSPACKAGROOT_VW |
| 13 | QUALIFYPATH | Character(127) | VARCHAR2(127) NOT NULL |
Qualified Package/Class Path
Prompt Table: PSPACKAGPATH_VW |
| 14 | APPCLASSID | Character(30) | VARCHAR2(30) NOT NULL |
Application Class ID
Prompt Table: PSPACKAGCLAS_VW |
| 15 | REPORT_DEFN_ID | Character(12) | VARCHAR2(12) NOT NULL | Report Name (see PSXPRPTDEFN). |
| 16 | DS_ID | Character(30) | VARCHAR2(30) NOT NULL | Data Source ID |
| 17 | DATA_EXISTS | Character(1) | VARCHAR2(1) NOT NULL |
Data Exists
Y/N Table Edit |
| 18 | GROUPNAME | Character(50) | VARCHAR2(50) NOT NULL | Directory Group Name |
| 19 | HCSC_SS_RPTTITLE | Character(60) | VARCHAR2(60) NOT NULL | Report Title for Self-Service Page. |
| 20 | HCSC_SS_RPTNAME | Character(30) | VARCHAR2(30) NOT NULL | SS Report Name |
| 21 | HCSC_REPORT_DT | Date(10) | DATE | Self Service Report Availability Date |