SCC_BRINCD_NLDPrompt Table: SCC_BRINCD_NLD
SSR_BR_ST_DT_NLDPrompt Table: SSR_BR_PDS_SRCH
SSR_BR_END_DT_NLDPrompt Table: SSR_BR_PDE_SRCH
SSR_BR_CREATE_DTSSR_BR_RO_SRCH(SQL View) |
Index Back |
|---|---|
Search record for RO |
| SELECT SCC_BRINCD_NLD ,SSR_BR_ST_DT_NLD ,SSR_BR_END_DT_NLD , SSR_BR_CREATE_DT FROM PS_SSR_BR_VLP_RO |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCC_BRINCD_NLD |
Character(4) | VARCHAR2(4) NOT NULL |
BRINcode
Prompt Table: SCC_BRINCD_NLD |
| 2 | SSR_BR_ST_DT_NLD |
Date(10) | DATE NOT NULL |
Start Date
Prompt Table: SSR_BR_PDS_SRCH |
| 3 | SSR_BR_END_DT_NLD |
Date(10) | DATE NOT NULL |
End Date
Prompt Table: SSR_BR_PDE_SRCH |
| 4 | SSR_BR_CREATE_DT |
Date(10) | DATE | Creation Date |