OWNERSHIP_IDBUSINESS_UNITAGENDA_ID1=High
2=Medium
3=Low
FO_BRN_AGNDA_V2(SQL View) |
Index Back |
|---|---|
Branch Agenda ViewOpen Agenda Items |
| SELECT DTL.OWNERSHIP_ID , DTL.BUSINESS_UNIT , DTL.AGENDA_ID , DTL.AGENDA_PRIORITY , DTL.CUST_ID , DTL.EVENT_TYPE , STP.DESCR ,DTL.FO_SUBEVENT , DTL.OPRID , DTL.CANDIDATE_ID , DTL.SO_ID , DTL.SO_LINE , DTL.CONTACT_ID , DTL.START_DATE , DTL.END_DATE ,DTL.START_TIME ,DTL.END_TIME ,DTL.FO_DATE FROM PS_FO_AGENDA_DTL DTL , PS_FO_EVENTS_SETUP STP WHERE DTL.COMPLETED = 'N' AND DTL.END_DATE >= %CurrentDateIn AND STP.EVENT='TMP' AND STP.EVENT_TYPE=DTL.EVENT_TYPE AND STP.FO_EVNT_PROC<>'Y' AND STP.FO_CHECK1_PB='Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OWNERSHIP_ID |
Character(30) | VARCHAR2(30) NOT NULL | Owning Organization |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | AGENDA_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Agenda ID |
| 4 | AGENDA_PRIORITY | Character(4) | VARCHAR2(4) NOT NULL |
Agenda Priority
1=High 2=Medium 3=Low |
| 5 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. |
| 6 | EVENT_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Event Type |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 8 | FO_SUBEVENT | Character(10) | VARCHAR2(10) NOT NULL | Staffing Front Office Recruiting Funnel SubEvent |
| 9 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 10 | CANDIDATE_ID | Character(11) | VARCHAR2(11) NOT NULL | Used as a general ID for anything from Employee id to other types of ID like asset and material. |
| 11 | SO_ID | Character(15) | VARCHAR2(15) NOT NULL | Service Order ID |
| 12 | SO_LINE | Number(3,0) | SMALLINT NOT NULL | Line Number |
| 13 | CONTACT_ID | Character(15) | VARCHAR2(15) NOT NULL | Contact Identifier for Treasury Contacts |
| 14 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 15 | END_DATE | Date(10) | DATE | End Date |
| 16 | START_TIME | Time(15) | TIMESTAMP | Start of Shift |
| 17 | END_TIME | Time(15) | TIMESTAMP | End of Shift |
| 18 | FO_DATE | Date(10) | DATE | Date |