PNLGRPNAMEPrompt Table: PSPNLGRPDEFN
MARKETSEQNO0=Level 0
1=Level 1
Prompt Table: WL_RECORD_VW
Prompt Table: WL_RECORD2_VW
Prompt Table: WL_RECFIELD_VW
1=Formatted Value
2=Field Name
4=Value
HRS_CRSPTMP_VAR(SQL Table) |
Index Back |
|---|---|
ARM TokensUsed to define taken for ARM templates |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PNLGRPNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Component Name
Prompt Table: PSPNLGRPDEFN |
| 2 | MARKET |
Character(3) | VARCHAR2(3) NOT NULL | Market |
| 3 | SEQNO |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | WL_OCCURS | Character(1) | VARCHAR2(1) NOT NULL |
Occurs Level
0=Level 0 1=Level 1 |
| 6 | WL_TOKENID | Character(10) | VARCHAR2(10) NOT NULL | Value |
| 7 | WL_RECNAMEPRIMARY | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name
Prompt Table: WL_RECORD_VW |
| 8 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: WL_RECORD2_VW |
| 9 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: WL_RECFIELD_VW |
| 10 | WL_DISPLAY_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Different ways to display a field value
1=Formatted Value 2=Field Name 4=Value |
| 11 | HRS_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Row Added DateTime |
| 12 | HRS_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Added Operator Id |
| 13 | HRS_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Row Updated DateTime |
| 14 | HRS_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Updated Operator Id |