GP_RSLT_ADM_DTL(SQL Table) |
Index Back |
---|---|
Results Setup DetailPayee Detail Fields for Administrator Results Summary Page |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: GP_COUNTRY |
2 | GP_ELN_SET | Character(15) | VARCHAR2(15) NOT NULL | Element Set |
3 | SEQ_NO | Number(2,0) | SMALLINT NOT NULL | Sequence Number |
4 | GP_RSLT_ADM_FLDTYP | Character(2) | VARCHAR2(2) NOT NULL |
The type of Payee Detail field defined for the Administrator Summary page.
01=Payment Key 02=Absence/Payroll Results |
5 | GP_RSLT_ADM_PMTKEY | Character(2) | VARCHAR2(2) NOT NULL |
This field defines which payment key will be displayed in the Payee Details grid on the Administrator Results Summary page.
01=Payment Key 1 02=Payment Key 2 03=Payment Key 3 04=Payment Key 4 |
6 | ENTRY_TYPE_ID | Character(3) | VARCHAR2(3) NOT NULL |
Element Entry Type ID
Prompt Table: GP_ENT_GRBRK_VW |
7 | PIN_NUM | Number(8,0) | INTEGER NOT NULL |
PIN Number
Prompt Table: %GP_EDIT_FLD7 |
8 | GP_RSLT_ADM_LBLTYP | Character(2) | VARCHAR2(2) NOT NULL |
Defines what to use as label in result adminstrator view. Has XLATs
01=Element Name 02=Element Description 03=Message Catalog 04=Text |
9 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
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: PSMSGSETDEFN |
11 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
Prompt Table: PSMSGCATDEFN |
12 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: GP_ADM_REC_VW |
13 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: GP_ADM_FLD_VW |
14 | SYSPIN_SETID_IND | Character(1) | VARCHAR2(1) NOT NULL |
SetID Controlled
Y/N Table Edit Default Value: N |