COUNTRYPrompt Table: GP_CNTRY_OP_VW
ABS_PIN_CODEPrompt Table: GP_ABS_PIN_CVW
PIN_TAKE_NUMGP_ABS_ADD_SS(SQL View) |
Index Back |
|---|---|
Add search rec country/takeAdd search record for the country/take configuration |
| SELECT 'AAA' , 'AAAAAAAAAAAAAAAAAAAAAA' ,1 , 'AAAAAAAAAAAAAAAAAA' 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 | ABS_PIN_CODE |
Character(22) | VARCHAR2(22) NOT NULL |
Constructed from PIN_NM + COUNTRY of the element definition (GP_PIN)
Prompt Table: GP_ABS_PIN_CVW |
| 3 | PIN_TAKE_NUM |
Number(8,0) | INTEGER NOT NULL | Absence Take |
| 4 | PIN_NM | Character(18) | VARCHAR2(18) NOT NULL | Element Name field |