GP_NRP_RSADM_AD(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 | GP_PKG_ID | Character(10) | VARCHAR2(10) NOT NULL | Field used for element packaging |
2 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
3 | GP_ELN_SET | Character(15) | VARCHAR2(15) NOT NULL | Element Set |
4 | SEQ_NO | Number(2,0) | SMALLINT NOT NULL | Sequence Number |
5 | 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 |
6 | 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 |
7 | ENTRY_TYPE_ID | Character(3) | VARCHAR2(3) NOT NULL | Element Entry Type ID |
8 | PIN_NUM | Number(8,0) | INTEGER NOT NULL | PIN Number |
9 | 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 |
10 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
11 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
12 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
13 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
14 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
15 | SYSPIN_SETID_IND | Character(1) | VARCHAR2(1) NOT NULL | SetID Controlled |