COUNTRYPrompt Table: GP_COUNTRY_VW
GP_TX_TYPEA=Advance
M=Manual Payment
R=Correction
U=Additional Payment
GP_TX_REASONA=All
L=Limited Element Set
P=Elements with Positive Input
GP_NRP_OCS_M_VW(SQL View) |
Index Back |
|---|---|
Manual Payment ConfigurationConfiguration for Off cycle Manual Payment display |
| SELECT COUNTRY , GP_TX_TYPE , GP_TX_REASON , DESCR , DESCRSHORT , HIDE_SECTION_IND , ALLW_BGN_DT_IND , ALLW_END_DT_IND , HIDE_SECTION2_IND , RUN_TYPE , ALLW_RUN_TYPE_IND , GP_ELEM_PRC_OPTN , ALLW_ELEM_PRC_IND , PIN_ELEM_GRP_NUM +50000000 , ALLW_PMT_KEYS_IND FROM PS_GP_OC_SETUP_M |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: GP_COUNTRY_VW |
| 2 | GP_TX_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Transaction Type (introduced with Off-cycle). Identifies an offcycle request as correction,manual payment, unscheduled payment or advance.
XLAT values are assigned to support batch processing order
A=Advance M=Manual Payment R=Correction U=Additional Payment |
| 3 | GP_TX_REASON |
Character(18) | VARCHAR2(18) NOT NULL | Off Cycle (Transaction) Reason Identifies a particular configuration to be applied to the presentation of off cycle request information |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 6 | HIDE_SECTION_IND | Character(1) | VARCHAR2(1) NOT NULL | Hide Calendar Controls |
| 7 | ALLW_BGN_DT_IND | Character(1) | VARCHAR2(1) NOT NULL | Allow entry of Begin Date |
| 8 | ALLW_END_DT_IND | Character(1) | VARCHAR2(1) NOT NULL | Allow entry of End Date |
| 9 | HIDE_SECTION2_IND | Character(1) | VARCHAR2(1) NOT NULL | YesNo edit controls the display of a section (group box) |
| 10 | RUN_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Run Type Name |
| 11 | ALLW_RUN_TYPE_IND | Character(1) | VARCHAR2(1) NOT NULL | Allow entry of Run Type |
| 12 | GP_ELEM_PRC_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Helps user select what "Big Stuff" elements to process during a given calendar (off cycle). All, only those with PI, or a limited identified set
A=All L=Limited Element Set P=Elements with Positive Input |
| 13 | ALLW_ELEM_PRC_IND | Character(1) | VARCHAR2(1) NOT NULL | Allow entry of Element Select |
| 14 | PIN_ELEM_GRP_NUM | Number(8,0) | INTEGER NOT NULL | PIN Number for Element Group |
| 15 | ALLW_PMT_KEYS_IND | Character(1) | VARCHAR2(1) NOT NULL | Allow entry of Payment Keys |