COUNTRYPrompt Table: GP_CNTRY_OP_VW
PIN_NMPrompt Table: GP_ABS_PIN_VW
PIN_TAKE_NUMGP_ABS_ADD_SS(SQL View) |
Index Back |
|---|---|
Add search rec country/takeAdd search record for the country/take configuration |
| SELECT 'AAA' , 'AAAAAAAAAAAAAAAAAA' , 1 FROM PS_INSTALLATION |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: GP_CNTRY_OP_VW |
| 2 | PIN_NM |
Character(18) | VARCHAR2(18) NOT NULL |
Element Name field
Prompt Table: GP_ABS_PIN_VW |
| 3 | PIN_TAKE_NUM |
Number(8,0) | INTEGER NOT NULL | Absence Take |