GP_ABS_SEC_COUNTRYPrompt Table: GP_COUNTRY
GP_ABS_CS_SEC_IDDefault Value: 1
GP_ABS_PG0SCVW(SQL View) |
Index Back |
|---|---|
Template Section ViewConfigurable Sections: View against the Template Section Setup table returning only the page zero configuration sections. |
| SELECT COUNTRY , GP_ABS_CS_SEC_ID , SEQ_NBR FROM PS_GP_ABS_SECDEFN WHERE GP_ABS_CS_SEC_ID IN ('TBH_PAGE_ZERO', 'TBH_PAGE_ZERO_FED') AND COUNTRY = 'USA' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GP_ABS_SEC_COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL |
Section Country
Prompt Table: GP_COUNTRY |
| 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 |