TRN2483_CPNYITS(SQL Table) |
Index Back |
---|---|
2483 Company Details2483 Company Details |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
2 | DECL_YR_2483_FRA | Number(4,0) | SMALLINT NOT NULL | French Report 2483 : Declaring Year |
3 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
4 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
5 | CHARGEABLE_SW_FRA | Character(1) | VARCHAR2(1) NOT NULL |
Chargeable switch
Y/N Table Edit Default Value: N |