GP_ABS_SEC_VW3(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 |