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 |