TRN2483_CPNYITS

(SQL Table)
Index Back

2483 Company Details

2483 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