WP_AGRT_GRP_IDWP_AGRT_CPNY_VW(SQL View) |
Index Back |
|---|---|
Profit-Sharing Company ViewProfit-Sharing Company View |
| SELECT A.COMPANY , A.DESCR FROM PS_COMPANY_TBL A WHERE %EffdtCheck(COMPANY_TBL, A, %currentdatein) AND A.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | WP_AGRT_GRP_ID |
Character(10) | VARCHAR2(10) NOT NULL | Profit Sharing Agreement Group ID |
| 2 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |