COUNTRYPrompt Table: GP_COUNTRY_VW
GP_ABS_CS_SEC_IDDefault Value: 1
GP_ABS_SEC_VW2(SQL View) |
Index Back |
|---|---|
Template Section ViewConfigurable Sections: View against the Template Section Setup table returning all sections except the page zero configuration sections. |
| SELECT COUNTRY , GP_ABS_CS_SEC_ID , SEQ_NBR FROM PS_GP_ABS_SECDEFN WHERE NOT(GP_ABS_CS_SEC_ID = 'ABS_PAGE_ZERO' AND COUNTRY = 'USA') |
| # | 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_ABS_CS_SEC_ID |
Character(18) | VARCHAR2(18) NOT NULL | Template Section ID |
| 3 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL |
Sequence Number
Default Value: 1 |