This discussion is archived
6 Replies Latest reply: Jun 21, 2013 8:00 AM by Yacouba RSS

OTL Timecard Status

Avinash Journeyer
Currently Being Moderated
Hi All,

If possible i need some quick update and suggestions on below points:-

When we submit the timecard status changes to "Submitted" from WIP. And when manager approves the timecard status goes to "Approved" mode. Similarly when have many other statuses (Error, Rejected etc...). Now if we transfer the timecard to payroll (through BEE) what is the status of timecard? as far as I know it is still Approved.

If there is no standard ststus for this scenarion (timecard transferred to BEE) we need to develope a query to know if the timecard has been transferred to BEE and will then use this query in custom form to show the status (Transferred to BEE).

Please share your ideas and query.

Thanks,
Avinash
  • 1. Re: OTL Timecard Status
    Vigneswar Battu Guru
    Currently Being Moderated
    Hi Avinash,

    There is no specific status for the transferred card.
    There is a column transferred_to in the table hxc_timecard_summary which you can use.
    select transferred_to from hxc_timecard_summary
    where rownum < 3 ;
    Cheers,
    Vignesh
  • 2. Re: OTL Timecard Status
    Avinash Journeyer
    Currently Being Moderated
    Thanks Vignesh,

    But strangely I did not see this column in the table hxc_timecard_summary:-

    desc hxc_timecard_summary
    Name Null Type
    --------------------- -------- -------------
    TIMECARD_ID NOT NULL NUMBER
    TIMECARD_OVN NOT NULL NUMBER
    APPROVAL_STATUS NOT NULL VARCHAR2(30)
    RESOURCE_ID NOT NULL NUMBER
    START_TIME NOT NULL DATE
    STOP_TIME NOT NULL DATE
    RECORDED_HOURS NOT NULL NUMBER
    HAS_REASONS NOT NULL VARCHAR2(1)
    SUBMISSION_DATE DATE
    APPROVAL_ITEM_TYPE VARCHAR2(8)
    APPROVAL_PROCESS_NAME VARCHAR2(30)
    APPROVAL_ITEM_KEY VARCHAR2(240)
    ATTRIBUTE_CATEGORY VARCHAR2(30)
    ATTRIBUTE1 VARCHAR2(150)
    ATTRIBUTE2 VARCHAR2(150)
    ATTRIBUTE3 VARCHAR2(150)
    ATTRIBUTE4 VARCHAR2(150)
    ATTRIBUTE5 VARCHAR2(150)
    ATTRIBUTE6 VARCHAR2(150)
    ATTRIBUTE7 VARCHAR2(150)
    ATTRIBUTE8 VARCHAR2(150)
    ATTRIBUTE9 VARCHAR2(150)
    ATTRIBUTE10 VARCHAR2(150)
    ATTRIBUTE11 VARCHAR2(150)
    ATTRIBUTE12 VARCHAR2(150)
    ATTRIBUTE13 VARCHAR2(150)
    ATTRIBUTE14 VARCHAR2(150)
    ATTRIBUTE15 VARCHAR2(150)
    ATTRIBUTE16 VARCHAR2(150)
    ATTRIBUTE17 VARCHAR2(150)
    ATTRIBUTE18 VARCHAR2(150)
    ATTRIBUTE19 VARCHAR2(150)
    ATTRIBUTE20 VARCHAR2(150)
    ATTRIBUTE21 VARCHAR2(150)
    ATTRIBUTE22 VARCHAR2(150)
    ATTRIBUTE23 VARCHAR2(150)
    ATTRIBUTE24 VARCHAR2(150)
    ATTRIBUTE25 VARCHAR2(150)
    ATTRIBUTE26 VARCHAR2(150)
    ATTRIBUTE27 VARCHAR2(150)
    ATTRIBUTE28 VARCHAR2(150)
    ATTRIBUTE29 VARCHAR2(150)
    ATTRIBUTE30 VARCHAR2(150)
    TK_AUDIT_ITEM_TYPE VARCHAR2(8)
    TK_AUDIT_PROCESS_NAME VARCHAR2(30)
    TK_AUDIT_ITEM_KEY VARCHAR2(240)
    DATA_SET_ID NUMBER(15)
    ABSENCE_DAYS NUMBER
    ABSENCE_HOURS NUMBER


    If you have any idea could you please let me know what could be possible value of this column once timecard is transferred to BEE. I hope this column is linked with any LOV to contain list of valid entry. By any chance do you know the name of that LOV so that I can check the values from front end as I can not see it from backend.


    Thanks again for all your help.


    Thanks,
    Avinash
  • 3. Re: OTL Timecard Status
    GiuseppeBonavita Journeyer
    Currently Being Moderated
    after the transfer of a tiecard to an external application you create another record at timecard level:

    select time_building_block_id
    ,resource_id
    ,start_time
    ,stop_time
    ,scope
    ,approval_status
    ,(select application_set_name from hxc_application_sets_v where application_set_id = h.application_set_id)
    from hxc_time_building_blocks h
    where scope in ('APPLICATION_PERIOD', 'TIMECARD')
    and date_to = '31-dec-4712'
    order by resource_id, start_time, scope desc, approval_status
  • 4. Re: OTL Timecard Status
    Vigneswar Battu Guru
    Currently Being Moderated
    Hi Avinash,

    What insstance are you working on ?

    we're on 12.1.3 -
    desc hxc_timecard_summary
    Name                  Null     Type          
    --------------------- -------- ------------- 
    TIMECARD_ID           NOT NULL NUMBER        
    TIMECARD_OVN          NOT NULL NUMBER        
    APPROVAL_STATUS       NOT NULL VARCHAR2(30)  
    RESOURCE_ID           NOT NULL NUMBER        
    START_TIME            NOT NULL DATE          
    STOP_TIME             NOT NULL DATE          
    RECORDED_HOURS        NOT NULL NUMBER        
    HAS_REASONS           NOT NULL VARCHAR2(1)   
    ..
    ..
    ..
    ABSENCE_DAYS                   NUMBER        
    ABSENCE_HOURS                  NUMBER        
    TRANSFERRED_TO                 VARCHAR2(240) 
    Alternatively, you can also use the solution provided by Giuseppe

    Also, please close the thread if you're done with it.. might help others..

    Satish,
    Are you not able to use any of the solutions provided above ?

    Cheers,
    Vignesh
  • 5. Re: OTL Timecard Status
    603257 Journeyer
    Currently Being Moderated
    You could always check hxt_timecards_x and check whether the data has gone across?
  • 6. Re: OTL Timecard Status
    Yacouba Newbie
    Currently Being Moderated

    Sorry I'm new on HXC, but I have to edit business report on Timecard scoope. Can you give more about table and link on each other:

    - HXC_TIMECARD_SUMMARY

     

    - HXC_TK_GROUP_QUERIES

     

    - HXC_TK_GROUP_QUERY_CRITERIA

     

    - HXC_TIME_BUILDING_BLOCKS

     

    Or give me link where a can find and understand easyly what I'm looking for...

     

    Thanks a lot...

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points