GPES_EMP_STOCKS(SQL Table) |
Index Back |
---|---|
Employee Stock DispositionEmployee Stock Disposition. Used to employee data of stocks: generation period, maintenance period, amount, pasive employee, general plan and sales date. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
2 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
3 | SEQNUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |
4 | GPES_SALES_DATE | Date(10) | DATE NOT NULL |
Sales date
Default Value: %date |
5 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
6 | GPES_PRD_GEN_STOCK | Number(5,2) | DECIMAL(4,2) NOT NULL | Generation Period of Stocks |
7 | GPES_PRD_MNT_STOCK | Number(5,2) | DECIMAL(4,2) NOT NULL | Maintenance Period of Stocks |
8 | GPES_AMOUNT_STOCK | Number(11,2) | DECIMAL(10,2) NOT NULL | Amount of Employee Stock |
9 | GPES_PAS_EMP_STOCK | Character(1) | VARCHAR2(1) NOT NULL |
Pasive Employee of Stock
Default Value: N |
10 | GPES_GENRL_PLAN_ST | Character(1) | VARCHAR2(1) NOT NULL |
General Plan of Employee Stock
Default Value: N |