UPG_CONV_TL(SQL Table) |
Index Back |
|---|---|
TL Conversion Defaults |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: BUS_UNIT_TBL_HR |
| 2 | SETID_DEPT | Character(5) | VARCHAR2(5) NOT NULL |
Department SetID
Prompt Table: SETID_TBL |
| 3 | SETID_JOBCODE | Character(5) | VARCHAR2(5) NOT NULL | Job Code SetID |
| 4 | SETID_LOCATION | Character(5) | VARCHAR2(5) NOT NULL | Location SetID |
| 5 | COUNTER | Number(10,0) | DECIMAL(10) NOT NULL |
Counter
Default Value: 200 |
| 6 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL | Used on an approval rule set |
| 7 | SEND_TO_TCD | Character(1) | VARCHAR2(1) NOT NULL |
Send To TCD
Y/N Table Edit Default Value: N |
| 8 | COMMIT_ACCTG_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Commitment Accounting
Y/N Table Edit Default Value: N |
| 9 | UPG_TL_LOAD_FLDSEC | Character(1) | VARCHAR2(1) NOT NULL |
Load TL Field Security Table
Y/N Table Edit Default Value: Y |
| 10 | UPG_TRC_PROGRAM | Character(5) | VARCHAR2(5) NOT NULL | Time and Labor Upgrade to 8.0 TRC Program ID |