SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
BILLING_SPECIALISTPrompt Table: BI_SPECIALIST
BI_SPCLST_VW(SQL View) |
Index Back |
|---|---|
No EFFDT billing specilist vwThis View should be used when ever prompting for the billing specialist from an effective dated table. Example : CUST_OPTION is an effective dated table. Use this view to prompt for BILLING_SPECIALIST |
| SELECT A.SETID , A.BILLING_SPECIALIST , A.NAME1 FROM PS_BI_SPECIALIST A WHERE A.EFF_STATUS = 'A' AND %EffdtCheck(BI_SPECIALIST X, A, %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | BILLING_SPECIALIST |
Character(8) | VARCHAR2(8) NOT NULL |
Billing Specialist
Prompt Table: BI_SPECIALIST |
| 3 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |