| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 TCD_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Time Collection Device Identification.
|
| 2 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 3 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 4 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 5 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
Default Value: TL_TCD_TBL.DESCR
|
| 6 |
TCD_TYPE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Type of Time Collection Device
Prompt Table:
TL_TCDDEF_TBL
|
| 7 |
INSTALL_DT |
Date(10) |
DATE |
Installation date
Default Value: %date
|
| 8 |
TRC_PROGRAM |
Character(5) |
VARCHAR2(5) NOT NULL |
TRC Program ID
Prompt Table:
TL_TRC_PGM_TBL
|
| 9 |
TCD_NETWORK_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Network ID
|
| 10 |
TCD_NODE_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Terminal ID
|
| 11 |
MSGNODENAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
Prompt Table:
TL_MSGNODE_VW
|
| 12 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 13 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
STATE_TBL
|
| 14 |
LOCALITY |
Character(10) |
VARCHAR2(10) NOT NULL |
Locality
Prompt Table:
LOCAL_TAX_TBL
|
| 15 |
TIMEZONE |
Character(9) |
VARCHAR2(9) NOT NULL |
Time Zone
Prompt Table:
PSTIMEZONE
|
| 16 |
LANG_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
CFR=Canadian French
DAN=Danish
DUT=Dutch
ENG=English
ESP=Spanish
FRA=French
GER=German
GRK=Greek
INE=International English
ITA=Italian
JPN=Japanese
KOR=Korean
POR=Portuguese
SVE=Swedish
THA=Thai
ZHS=Simplified Chinese
ZHT=Traditional Chinese
|